Question on Package Variables
From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 24 Jan 2008 07:37:01 -0600
Message-ID: <umyqv2maq.fsf@rcn.com>
Date: 24 Jan 2008 07:37:01 -0600
Message-ID: <umyqv2maq.fsf@rcn.com>
CREATE OR REPLACE PACKAGE p_tst
IS
v_var int := 1;
END;
/
SQLPLUS> select p_tst.v_var from dual;
The above fails with an error of p_tst not a function (or something to that affect).
Is this based on the variable only being available in the PLSQL engine and not available in SQL or something else?
-- Galen BoyerReceived on Thu Jan 24 2008 - 07:37:01 CST