to_date nlsparam doesn't work in pl/sql?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 07 May 2002 01:45:38 GMT
Message-ID: <6lGB8.13876$M7.6442413@twister.socal.rr.com>

> select TO_DATE(' 2002-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') from dual;

TO_DATE('2002-04-010

---

01-APR-2002 00:00:00 1 row selected.

> declare

2 d date;
3 begin
4 d := TO_DATE(' 2002-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN');
5 end;
6 /

declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 4

SQL*Plus: Release 9.0.1.3.0 - Production on Mon May 6 18:41:07 2002 Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production With the Partitioning option
JServer Release 9.0.1.3.0 - Production

Thanks,
Richard Received on Mon May 06 2002 - 20:45:38 CDT