Table of Contents

Operation and Object Type	Packaging FolderFolders (fixed folders)	Package Methods (flexible folders)	Archived
CREATE/ALTER/DROP DATABASE LINK	`sql_direct`	direct	Yes
CREATE/ALTER/DROP FUNCTION	`function`	storedlogic	No
CREATE/ALTER/DROP INDEX	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP PROCEDURE	`procedure`	storedlogic	No
CREATE/ALTER/DROP QUEUE	`sql_direct`	direct	Yes
CREATE/ALTER/DROP SEQUENCE	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP SYNONYM	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP TABLE	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
CREATE/ALTER/DROP TRIGGER	`trigger`	storedlogic	No
CREATE/ALTER/DROP TYPE	`sql_direct`	direct	Yes
CREATE/ALTER/DROP VIEW	`view`	storedlogic	No
CREATE/ALTER/DROP VIEW INDEX	`ddl, ddl_direct, sql_direct`	convert, ddl_direct, direct	Yes
RENAME <DB_OBJECT>	`sql_direct`	direct	Yes

Operation	Packaging Folder (fixed folders)	Package Method (flexible folders)	Archived
INSERT, UPDATE, DELETE, SELECT	data_dml	data_dml	Yes
GRANT, REVOKE	sql_direct	direct	Yes

Error Handling

Do not put error-handling statements in the SQL scripts.

...

Versions Compared