Re: Public constants in package

From: Walt <walt_askier_at_yahoo.com>
Date: Fri, 22 Apr 2011 10:22:24 -0400
Message-ID: <Aagsp.42380$7k6.2342_at_en-nntp-16.dc1.easynews.com>

On 4/19/2011 12:44 PM, John Hurley wrote:
> Walt:
>
> # select mypackage.myconstant from dual
>
> Pretty basic concept here ... when you execute SQL ( like select
> column from dual ) you are executing SQL ... not PLSQL.
>
> You can via a context switch have the SQL statement invoke a PLSQL
> function ( but of course that takes overhead and not nearly as fast as
> real SQL even real SQL with the Oracle extensions of SQL ).
>
> Oracle SQL cannot peer inside packages and see the constants. It does
> not work that way.
>
> Oracle PLSQL outside the package could see the constant.

Thanks. It makes sense now.

//Walt Received on Fri Apr 22 2011 - 09:22:24 CDT