How to change date format in a PL/SQL block.
From: Ruby Goel <ruby.goel_at_amd.com>
Date: 1996/05/03
Message-ID: <318A76B2.725_at_amd.com>#1/1
Date: 1996/05/03
Message-ID: <318A76B2.725_at_amd.com>#1/1
I want to set date format to "DD-MON-YYYY HH24:MI:SS" from PL/SQL block. I can not use following (because PL/SQL does not support ALTER statements)
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';
I tried using following too :
dbms_session.set_nls( 'nls_date_format', '''DD-MON-YYYY
HH24:MI:SS''');
This gave me following error :
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.DBMS_SESSION, line 39
If anybody has a solution please let me know.
Thanks
Ruby
Received on Fri May 03 1996 - 00:00:00 CEST