Re: Question on Package Variables

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 Boyer