Help on using Package constants within a SQL Statement

Hi,

I was wondering if anybody could give me some direction as to how I could
use a literal that is declared within a package in my SQL statement. Note the statement will be external to the package.

e.g. the literals would be defined in a package something like this:

CREATE OR REPLACE Package my_Literals AS   Timeframe_Immediate CONSTANT VARCHAR2(4) := 'IMMED'; END my_Literals;

I now want to reference the CONSTANT Timeframe_Immediate in a SQL statement
external to the package, something like:

   SELECT my_Literals.Timeframe_Immediate FROM DUAL;

Thanks in advance
Romeo D'Souza Received on Tue Sep 09 1997 - 00:00:00 CDT