Re: Question on Package Variables

From: Galen Boyer <>
Date: 24 Jan 2008 18:22:04 -0600
Message-ID: <>

On Thu, 24 Jan 2008, 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
Received on Thu Jan 24 2008 - 18:22:04 CST

Original text of this message