Re: How to change date format in a PL/SQL block.

Ruby Goel wrote:
>
> 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

Hi,

Did you try the DBMS_DDL package ?

Yves Bergeron. Received on Sat May 04 1996 - 00:00:00 CEST