On Thu, 20 Dec 2007, 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.
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
Received on Sat Dec 22 2007 - 15:11:02 CST
