CREATE OR REPLACE PACKAGE BODY DROP_CREATE_TABLES_NIGHTLY IS ------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------- /* procedure 'W' is a wrapper for DBMS output. Placed at top of package to make globally available*/ PROCEDURE W(STR VARCHAR2) IS BEGIN /* setting variable to simpler to use STR variable for outputting */ DBMS_OUTPUT.PUT_LINE(STR); END; ------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------- /* procedure purpose: For dropping previously archived tables so that new ones can be created */ PROCEDURE DROP_ARCHIVED_TABLES IS BEGIN NULL; END; ------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------- PROCEDURE CREATE_NEW_ARCHIVED_TABLES IS BEGIN EXCEPTION WHEN OTHERS THEN /* will output an error message and indicate where errors exist */ W('EXCEPTION: ' || SQLCODE || ' IN ARCHIVE_ALL_TABLES. ERROR MESSAGE: ' || SQLERRM); END; ------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------- PROCEDURE BUILD_ARCHIVED_TABLES IS BEGIN NULL; END; --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------BEGIN /* package begin will be null for compiling purposes... would use for cleaning up but unnecessary to touch otherwise */ NULL;END DROP_CREATE_TABLES_NIGHTLY;
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.