Can any one explain procedure calling another procedure, procedure within procedure, procedure for updation i need with time stamp, system exception, user define exception.
Can any one explain procedure calling another procedure, procedure within procedure, procedure for updation i need with time stamp, system exception, user define exception.
To call procedure1 from proceudre2 use the following syntax
create or replace procedure2 as
begin
procedure1(parameters);
end procedure2;
/
procedure within procedure
create or replace procedure welcome as
procedure welcome_print(s char) as
begin
dbms_output.put_line('welcome to ' || s);
end;
begin
welcome_print('geekinterview.com');
end;
/
Last edited by krishnaindia2007; 03-14-2008 at 05:34 AM.
Please find a related discussion here.