Re: Question on Package Variables
Date: 24 Jan 2008 18:22:04 -0600
On Thu, 24 Jan 2008, edprochak_at_gmail.com wrote:
> the variable is not available to SQL because the interface between SQL
> (e.g. sqlplus or embedded SQL) and PL/SQL is by invoking a FUNCTION in
> a SQL statement or executing a PROCEDURE. SQL and PL/SQL are different
> languages (though they kissing cousins).
I was talking to another fellow and he and I thought it might be because once Oracle started supporting the web and connection pools it became dangerous to expose a package variable since the state of the variable remains through the life of the connection effectively exposing subsequent operations to the whims of a previous operation.
I believe in Oracle 7 accessing a package variable was supported?
-- Galen BoyerReceived on Thu Jan 24 2008 - 18:22:04 CST