TOAD automatically generates a calling script when you use the debugger. So, yes, it can be done. Mike
On Fri, Mar 26, 2010 at 8:29 AM, ddf <[email protected]> wrote: > > > On Mar 26, 6:27 am, Vili <[email protected]> wrote: > > Hi all, > > > > I have a procedure > > > > PROCEDURE myProcedure( > > pinNumber IN tTable.nNumber%TYPE > > , pisName OUT tTable.sName%TYPE > > > > ) AS > > BEGIN > > --- stuff-- > > > > END myProcedure; > > > > Is it possible to create a calling script for this? Because I have > > lots of procedures with a lot of parameters and it would really speed > > up my work if it would be possible to create the calling script when > > needed. > > > > The calling script would be like this > > > > DECLARE > > pinNumber tTable.nNumber%TYPE; > > pisName tTable.sName%TYPE; > > BEGIN > > > > myProcedure( > > pinNumber > > , pisName > > ); > > > > END; > > > > Cheers, Tuomo > > It appears you've written your calling script. > > > 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 > > To unsubscribe from this group, send email to oracle-plsql+ > unsubscribegooglegroups.com or reply to this email with the words "REMOVE > ME" as the subject. > -- 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 To unsubscribe from this group, send email to oracle-plsql+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
