On Oct 3, 2:18 am, krish newlife <[email protected]> wrote:
> create or replace procedure p1
> is
> procedure p2;
> procedure p3;
> begin
> p2(
> .....................
> ...................
> ...................
> exception
> ..............
>
> p3(
> .........
> ............
> ......
>
> exception
>
> )
>
> )
Are you wanting to call these internal procedures separately? If so
then you're 'barking up the wrong tree', so to speak. What you are
looking for (if I read this correctly) is a package:
create or replace package p1
is
begin
procedure p2;
procedure p3;
end;
/
create or replace package body p1
is
begin
p2(
.....................
...................
...................
exception
..............
p3(
.........
............
......
exception
)
)
Now you can call p1.p2 and/or p1.p3 successfully; you can't do that
the way you are trying to write this as p2 and p3 will need to be
called from within p1.
David Fitzjarrell
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
