Functions
From: Mtek <mtek_at_mtekusa.com>
Date: Fri, 20 Feb 2009 11:16:10 -0800 (PST)
Message-ID: <c468a5f4-da3f-4027-99db-1f528bbf27d7_at_m40g2000yqh.googlegroups.com>
Date: Fri, 20 Feb 2009 11:16:10 -0800 (PST)
Message-ID: <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 outside.
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? Received on Fri Feb 20 2009 - 13:16:10 CST