The only thing I can think of would be to use an anonymous block as these are unnamed are only useful for the current instance they were used in. You're allowed all the same luxuries that a stored procedure, but is not tied to the code-base at all thus eliminating any dependency to anything.
I do this all the time to test and verify results before placing into a package/procedure which is why it's the only things that came to mind unless I'm not understanding the question as well. -Ryan On Oct 3, 8:52 pm, krish newlife <krishnewl...@gmail.com> wrote: > actually the interviewer asked any alternative for calling procedures > instead of dependencies > > > > > > > > On Mon, Oct 3, 2011 at 11:04 AM, ddf <orat...@msn.com> wrote: > > > On Oct 3, 2:18 am, krish newlife <krishnewl...@gmail.com> 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 Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > 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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
