Re: Passing values between procedures(without actually passing them)

From: Sybrand Bakker <>
Date: Fri, 29 Jan 2010 23:50:24 +0100
Message-ID: <>

On Fri, 29 Jan 2010 05:09:21 -0800 (PST), LPF <> wrote:

>It's possible to achieve something like this?
>Procedure1(param1,param2) IS
>end Procedure1;

Did you try?
Apparently you didn't.
Scoping rules dictate param1 and param2 should be available at all lower levels, assuming you declared procedure2 locally to procedure1. If you didn't, it won't work.
As with most questions a quick glance in the Fine Manual would have provided the answer.
And, BTW, it is usually considered bad programming practice, being a recipe to make code unreadable.

Sybrand Bakker
Senior Oracle DBA Received on Fri Jan 29 2010 - 16:50:24 CST

Original text of this message