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>


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 Boyer
Received on Thu Jan 24 2008 - 07:37:01 CST

Original text of this message