Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Passsing parameters between procedures
Hi,
I currently have a package and contained within it I have 2 procedures.
The first procedure has a parameter (SEQ_ID) passed into it from a
sequence (sequence_name.NEXTVAL)
which works fine. What I need to do is to pass that parameter into
the other procedure as a variable which then get inserted into a table
and used in calculations for procedure 2.
Could someone please advise as to how I pass that parameter into the second procedure so that the variable can be initialised to the value.
Any advice would be great thanks. Received on Thu Dec 20 2007 - 08:30:41 CST
![]() |
![]() |