Hi, Thank you all for your replies.
Got a mail from Johnm that informed me to use ALL_ARGUMENTS view. With a small and simple script it can be used to create declarations and call for procedures and functions. >From Oracle SYS.ALL_ARGUMENTS The ALL_ARGUMENTS view lists the arguments of the procedures and functions that are accessible to the current user. On 26 maalis, 19:00, Michael Moore <[email protected]> wrote: > 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.
