christophercash_at_hotmail.com wrote:
> 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.
Is the second procedure called by the first? Could it be?
Is there an Oracle version number involved here?
Can you use CURRVAL?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Dec 20 2007 - 08:47:50 CST
