Re: Help on using Package constants within a SQL Statement

Romeo,

To refer to your literal:

Select * from table_name
where field1 = my_Literals.Timeframe_Immediate;

That's all there is to it. Just make sure that you load your literal package into the database before you load the package that will refer to the literal, or you will get an error.

Good luck.

Romeo D'Souza wrote:
>
> 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

|  Nathan G. Secrist  - Oracle DBA                              |
 -----------------------------------------------------------------
|  Evolving Systems, Inc.     |  Phone: (303) 802-1307          |
|  9777 Mount Pyramid Court   |    Fax: (303) 802-1420          |
|  Englewood, CO 80112        |  Email: nsecrist_at_evolving.com   |
-----------------------------------------------------------------