SELECT FROM PACKAGE

From: Monty <mmontreaux_at_hotmail.com>
Date: 3 Aug 2003 12:29:55 -0700
Message-ID: <6284dd3.0308031129.52178122@posting.google.com>

Hi, we are using a commercial piece of software that has all user error messages stored in an Oracle package. I am wanting to customize a bit of software and use the same messages (two packages, one in English and the other in Frence) but cannot find out how to retrieve the text from them. Here is an example:

CREATE OR REPLACE PACKAGE errMessages IS err1 CONSTANT VARCHAR2(100) := 'Illegal error due to...'; err2 VARCHAR2(100) := 'Invalid number in customer id...'; err3 VARCHAR2(100) := 'PLease reenter details for customer id'; END errMessages;
/

I want the select to return all the VARCHAR2 so I can see what they all are. But when I execute the below I get an error.

SQL>
SQL> SELECT errMessages.err1,errMessages.err2,errMessages.err3 FROM DUAL;
SELECT errMessages.err1,errMessages.err2,errMessages.err3 FROM DUAL

                                         *

ERROR at line 1:
ORA-06553: PLS-221: 'ERR3' is not a procedure or is undefined

SQL> 
SQL> 
SQL> 

I understand the error and what is wrong but still want to see the text in an SQL box. Can someone help please. Using Oracle 9 on a Win2K server.
Thank you
Monty Received on Sun Aug 03 2003 - 14:29:55 CDT