Packages

	groups logically related sub programs (procedures and functions).
	
	consists of 2 parts.
		specification
		body
	
	it cannot be invoked, parameterized or nested.

Advantages

it allows oracle server to read multiple objects into memory at once.

overloading.

users can declare global variables, global cursors and global user defined exceptions.

DBMS_JOBS

CREATE OR REPLACE PROCEDURE P1
AS
BEGIN
INSERT INTO T1 VALUES (1);
END;
/

DECLARE
X NUMBER;
BEGIN

DBMS_JOB.SUBMIT(
WHAT => 'P1;',
NEXT_DATE => SYSDATE,
INTERVAL => 'SYSDATE+1/1440',
JOB => X
);
COMMIT;

DBMS_OUTPUT.PUT_LINE(X);

END;
/

SELECT * FROM USER_JOBS;

BEGIN
DBMS_JOB.REMOVE(24);
END;
/

BEGIN
DBMS_JOB.BROKEN(86,FALSE);
END;
/

BEGIN
DBMS_JOB.BROKEN(86,TRUE);
END;
/

BEGIN
DBMS_JOB.RUN(86);
END;
/