SQL & PL/SQL

Hello,

i have I couple of procedures which were running perfectly on 10.2.0.1.

After the upgrade to 10.2.0.2 i get the error: ORA-01843: not a valid month ORA-06512: at "MASTERDBI.CREATE_OR_UPDATE_VER_INFO", line 65 ORA-06512: at line 1

This error is fired up, on an simple insert-stmt within the procedure. That means, that the date-parameter itself ist ok.

If I set the nls_date_format w/ "alter session...", then the procedure is running like before and everthing is fine. But this causes a big change on other programs. So I tried to set the nls_date_format w/in an schema.logon-trigger. But w/out success. The only solution is to set the nls_date_format explicit like in this example:

begin
execute immediate 'alter session set nls_date_format = "dd.mm.yyyy"';
create_or_update_ver_info(
10552,
'VC BK Zuordnung',
'TEST',
sysdate,
1);
end;

It seems, that oracle converts the date-param into a string a back again into a date. But, the date format expected is the american date format. The date format delivered is the german format. And this causes the fault.

Any comments...

Kind regards

Harald Simon

Message was edited by:
harald.simon@hew.de

Message was edited by:
harald.simon@hew.de