Re:Y2K problems with PL/SQL code

From: Harvey Mark <IMCEAMS-EARTH_PO1_msmrh>
Date: 1997/12/10
Message-ID: <14D46DF9FC08D111AF8700805F68C0CF055CCA_at_CONNERY>#1/1


        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 CET

Original text of this message