Oracle SQL plus error

From: <yuen_121_at_my-deja.com>
Date: Tue, 28 Nov 2000 01:34:57 GMT
Message-ID: <8vv240$nb8$1@nnrp1.deja.com>

Dear all,
If I execute the following SQL statment in the Oracle SQL *PLUS :  insert into testing values (TO_DATE('12-JAN-1999','DD-MON-YYYY'))

the following error occur:
 insert into testing values (TO_DATE('12-JAN-1999','DD-MON-YYYY'))

                                      *

 ERROR in row 1:
ORA-01843: not a valid month

But it worked fine in Oracle SQL *PLUS worksheet. Is there any environment variable need to set?

Thanks.

yuen_121

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 27 2000 - 19:34:57 CST