...
Operation and Object Type | Packaging FolderFolders (fixed folders) | Package Methods (flexible folders) | Archived |
|---|---|---|---|
CREATE/ALTER/DROP DATABASE LINK |
| direct | Yes |
CREATE/ALTER/DROP FUNCTION |
| direct | Yes |
CREATE/ALTER/DROP INDEX |
| convert, ddl_direct, direct | Yes |
CREATE/ALTER/DROP PROCEDURE |
| storedlogic | No |
CREATE/ALTER/DROP QUEUE |
| direct | Yes |
CREATE/ALTER/DROP SEQUENCE |
| convert, ddl_direct, direct | Yes |
CREATE/ALTER/DROP SYNONYM |
| convert, ddl_direct, direct | Yes |
CREATE/ALTER/DROP TABLE |
| convert, ddl_direct, direct | Yes |
CREATE/ALTER/DROP TRIGGER |
| storedlogic | No |
CREATE/ALTER/DROP TYPE |
| direct | Yes |
CREATE/ALTER/DROP VIEW |
| storedlogic | No |
CREATE/ALTER/DROP VIEW INDEX |
| convert, ddl_direct, direct | Yes |
RENAME <DB_OBJECT> |
| 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.
...