Re: Is FORMS 4.5 Y2K compliant ?

Hi

Brian is correct. v4.5 uses PL/SQl 1 which doesn't support the RR function. You have to write your own or use the database for conversions i.e select from dual

No way round unless you upgrade to Forms 5.

Richard Platt

Brian Membrey wrote in message <01be1851$46fdac40$1fa320cb_at_default>...
>I believe this depends on the version of 4.5 you are running. The RR
>format is not recognised by the PL/SQL available before 1.6.1 - I think it
>just ignores RR
>
>I've found the quickest workaround is to wrire a simple function which
>checks the format mask for RR and then either uses PL/SQL conversion (if
>not RR) or performs a SQL select if the mask contains RR
>
>I have a function to do this but not right at hand - email if you would
>like a copy!
>
>Regard
>s
>
>Alan Campbell <alan_at_mullen.demon.co.uk.nospam> wrote in article
><365aad66.709976_at_news.demon.co.uk>...
>> If I execute the follwoing code using FORMS 4.5 I get the error
>> ORA-01839 which is telling me that the day part of the date is not
>> valid for the month (the current system date is 29th February 2000).
>>
>> Current_Date := TO_CHAR(SYSDATE);
>>
>> MESSAGE(TO_CHAR(TO_DATE(Current_Date, 'DD-MON-RR')));
>>
>> Current date gets set to 20-FEB-00. the second line causes the error
>> mentioned above.
>>
>> If I execute the same code using SQL+ it works OK.
>>
>> select TO_CHAR(TO_DATE('29-FEB-00', 'DD-MON-RR'))
>> from sys.dual
>>
>> Gives me :-
>>
>> TO_CHAR(TO_DATE('29-FEB-00','DD-MON-RR'))
>>
>>
>---------------------------------------------------------------------------
>> 29-FEB-00
>>
>> Any ideas ?
>>
>> TIA
>>
>> Alan
>> ---
>> Alan Campbell
>> alan_at_mullen.demon.co.uk.nospam
>> Please remove .nospam to reply
>>
Received on Thu Nov 26 1998 - 01:23:01 CET