The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Thanks for the question, Susanto.

Asked: January 16, 2018 - 7:35 am UTC

Last updated: January 16, 2018 - 10:20 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Can we create nested package in PL/SQL like we do in Java? I mean can we create a package inside package in Oracle PL/SQL 11g?

and Chris said...

Nope:

create or replace package pkg as 
  package pkg_nested as 
    var integer;
  end;
end;
/
sho err

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/22     PLS-00103: Encountered the symbol "AS" when expecting one of the following:
         := . ( @ % ; not null range default character
5/1      PLS-00103: Encountered the symbol "END"

create or replace package pkg as 
  var int;
end;
/
sho err

No errors.

create or replace package body pkg as 
  package pkg_nested as 
    var integer;
  end;
end;
/
sho err

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/22     PLS-00103: Encountered the symbol "AS" when expecting one of the following:
         := . ( @ % ; not null range default character
5/1      PLS-00103: Encountered the symbol "END"

But you can nest procedures and functions within each other:

create or replace procedure p as
  procedure p_nest as
    procedure p_nest2 as
      procedure p_nest3 as
      begin
        dbms_output.put_line('Nested');
      end p_nest3;
    begin
      p_nest3();
    end p_nest2;
  begin
    p_nest2();
  end p_nest;

begin
  p_nest();
end p;
/

exec p();

Nested

We're not taking comments currently, so please try again later if you want to add a comment.

Breadcrumb

Question and Answer

You Asked

and Chris said...

More to Explore

PL/SQL demos

PL/SQL docs