Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Define Const for Date Format

Re: Define Const for Date Format

From: <sybrandb_at_yahoo.com>
Date: 13 Jul 2005 02:07:14 -0700
Message-ID: <1121245634.469537.8380@g43g2000cwa.googlegroups.com>


You can't refer to constants in a package directly. You need a function (more or less a method) in the package to retrieve the constant.

function get_date_format return varchar2 is return date_format;
end;

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jul 13 2005 - 04:07:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US