Hey all,
In 10.1.0.5.0, I have a procedure like this:
CREATE OR REPLACE PROCEDURE bleah AS
v_test VARCHAR2(50) := my_pkg.my_value('ABC');
BEGIN
DBMS_OUTPUT.PUT_LINE(v_test);
END bleah;
/
...where "my_pkg.my_value" is a function that reads a table and
returns a
column value of a row based on the supplied parameter, in this case
'ABC'.
From testing, I can change the column value for row 'ABC' in that
table (and
COMMIT) and the above procedure will reflect the change.
I would have suspected the v_test variable value to be retrieve at
compile
time, but I suppose that would be a maintenance nightmare since an
invalid
referenced object forces a recompile, right?
Also the CONSTANT keyword in the variable declaration does not
appear to
effect this behavior.
Is this documented somewhere? I've poked around the PL/SQL User's
Guide,
but can't find it.
TIA,
Rich
--
//www.freelists.org/webpage/oracle-l
