Skip to content

Instantly share code, notes, and snippets.

@KrashLeviathan

KrashLeviathan/package_ddl_script_example.sql

Created March 26, 2021 22:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KrashLeviathan/6edd8f87bd376e99ce7c3ef864991571 to your computer and use it in GitHub Desktop.
Save KrashLeviathan/6edd8f87bd376e99ce7c3ef864991571 to your computer and use it in GitHub Desktop.
Download ZIP
EXAMPLE: Scripting package DDL changes to run in SQL Developer console
Raw
package_ddl_script_example.sql
DECLARE
l_example_pkg_spec VARCHAR2(32767) := q'~
create or replace package EXAMPLE_PKG AS
-- spec definition here
end;
~';
l_example_pkg_body VARCHAR2(32767) := q'~
create or replace package body EXAMPLE_PKG AS
-- body definition here...
end;
~';
BEGIN
EXECUTE IMMEDIATE l_example_pkg_spec;
EXECUTE IMMEDIATE l_example_pkg_body;
-- ...
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment