Passsing parameters between procedures

From: <christophercash_at_hotmail.com>
Date: Thu, 20 Dec 2007 06:30:41 -0800 (PST)
Message-ID: <89fdd0b3-fe36-4318-a545-b3872c86a1d1@r60g2000hsc.googlegroups.com>

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