Using packaged constants in queries

From: Alexander Miroshnikov <alexander_miroshnikov_at_hotmail.com>
Date: Thu, 28 Feb 2002 10:05:24 +0000 (UTC)
Message-ID: <6e2c7cae5af1ab22f05aa11f8f30fada.73752@mygate.mailgate.org>

Dear colleagues,

I would like to take the constant declared in my package and use it in my query.

Please have a look at my test below -

test package create or replace package my_package as my_const constant integer := 1; end; /
test query select my_package.my_const from dual /
result select my_package.my_const from dual * ERROR at line 1: ORA-00904: invalid column name

Could you tell me why Oracle is unhappy and whether there is any way to use packaged constants in queries?

Many Thanks,

Alex

Oracle 8.1.7 for Solaris.

--

Posted via Mailgate.ORG Server - http://www.Mailgate.ORG Received on Thu Feb 28 2002 - 04:05:24 CST