Re: Passsing parameters between procedures

On Dec 20, 8:47 am, DA Morgan <damor..._at_psoug.org> wrote:
> christopherc..._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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Can you post the code for these procedures?

David Fitzjarrell Received on Thu Dec 20 2007 - 09:44:39 CST