Date: Sat, 21 Feb 2009 11:05:30 +0100
On 20.02.2009 22:03, gym dot scuba dot kennedy at gmail wrote:
> "Mtek" <mtek_at_mtekusa.com> wrote in message > news:c468a5f4-da3f-4027-99db-1f528bbf27d7_at_m40g2000yqh.googlegroups.com...
>> This is interesting. Say I have a package with a function in it. The
>> function is local to that package only and is not called from the
Here you have provided the explanation yourself.
>> Now, I have a line like this:
>> v_select := 'SELECT col1, col2, GET_PRICE(col3) FROM products';
>> open p_output for v_select;
>> That fails. But, if I create the function by itself, as a normal
>> function, then it works fine. Why is this?
> Because the function is private the the package. You would see that if you > didn't quote the cursor. If the function is public in the package then you > can do > > cursor foo is SELECT col1, col2, my_package.GET_PRICE(col3) get_price FROM > products;
Mtek, I suggest you read the basic documentation about PL/SQL:
robert Received on Sat Feb 21 2009 - 04:05:30 CST