Passsing parameters between procedures

#1

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.

#2

christophercash (AT) hotmail (DOT) com wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

On Dec 20, 8:47 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:

Quote:

christopherc... (AT) hotmail (DOT) 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...@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

#4

On Thu, 20 Dec 2007, christophercash (AT) hotmail (DOT) com wrote:

Quote:

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.

I'm confused. One procedure accepts a parameter and works fine. But,
you have a second procedure that needs to accept a parameter and you
aren't sure of the syntax? How come you can't follow the syntax of the
first procedure?

--
Galen Boyer

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Passsing parameters between procedures

comp.databases.oracle.misc comp.databases.oracle.misc

Passsing parameters between procedures - 12-20-2007 , 08:30 AM

Re: Passsing parameters between procedures - 12-20-2007 , 08:47 AM

Re: Passsing parameters between procedures - 12-20-2007 , 09:44 AM

Re: Passsing parameters between procedures - 12-22-2007 , 03:11 PM