Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re:Y2K problems with PL/SQL code
If you are using CHAR representations for dates in the code, you have problems. You
will have to manually change varchar lengths, formats manually. If at all possible use
DATE datatypes for all PL/SQL variables !!!! ( Including Parameters ).
Also look into the 'RR' date format offered by Oracle as a default at Database Level, Stored
in the Server ini file.
Mark Harvey.
> ----------
> From: vemp_at_aol.com (Vemp)[SMTP:vemp_at_aol.com]
> Posted At: 10 December 1997 03:58
> Posted To: tools
> Conversation: Y2K problems with PL/SQL code
> Subject: Y2K problems with PL/SQL code
>
> Hi all,
> Any ideas/pointers/insights will be greatly appreciated.
>
> thanks in advance
> vemp
>
Received on Wed Dec 10 1997 - 00:00:00 CST