actually the interviewer asked any alternative for calling procedures instead of dependencies
On Mon, Oct 3, 2011 at 11:04 AM, ddf <[email protected]> wrote: > > > 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 > -- 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
