ADP - Analyse, Design & Programmierung GmbH
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Nested procedures/functions in PL/SQL

create or replace procedure nesting_procedure(param in varchar2) 

is

  procedure nested_procedure is begin
    dbms_output.put_line('param is: ' || param);
  end nested_procedure;

begin
    nested_procedure;
end nesting_procedure;
/
SQL> exec nesting_procedure('foo bar')
param is: foo bar