Re: Public constants in package

From: John Hurley <>
Date: Tue, 19 Apr 2011 09:44:37 -0700 (PDT)
Message-ID: <>


# 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. Received on Tue Apr 19 2011 - 11:44:37 CDT

Original text of this message