date conversion in Form 4
From: wu litao <litao_at_CS.ColoState.EDU>
Date: 29 Sep 1994 23:35:50 GMT
Message-ID: <36fj0m$1krh_at_yuma.ACNS.ColoState.EDU>
Date: 29 Sep 1994 23:35:50 GMT
Message-ID: <36fj0m$1krh_at_yuma.ACNS.ColoState.EDU>
Hi Everyone,
The following select statement works fine under list of value of Form 4:
select field1,date_field,field3 from a_table;
BUT
select field1,TO_CHAR(date_field,'ddMONyy'),field3 from a_table;
DOES NOT!
The error message is: FRM-40502: ORACLE error -- unable to read list of values
I am using ORACLE 7 on Solaris 2.3
Could you tell me why and how to fix if you know the answer?
Email me pls since I seldom read news.
Thnx in advance!
-- Litao Wu Computer Science Department Phone: (303)543-0204 Colorado State University Email: litao_at_cs.colostate.edu Fort Collins, CO 80523Received on Fri Sep 30 1994 - 00:35:50 CET