Help: Using DBMS_SESSION to set NLS_DATE_FORMAT

From: Gerard M. Averill <gaverill_at_chsra.wisc.edu>
Date: Mon, 06 Jul 98 21:14:36 GMT
Message-ID: <6nrep2$g7g$1@news.doit.wisc.edu>

Am I missing something obvious here!? I'm looking to programatically set the NLS_DATE_FORMAT parameter using the SET_NLS procedure in the system package DBMS_SESSION. I can set this (and other formats):

begin
  dbms_session.set_nls('NLS_DATE_FORMAT', '''MM/DD/YYYYHH:MI:SS'''); end;

but not this (which is, of course, what I want):

begin
  dbms_session.set_nls('NLS_DATE_FORMAT', '''MM/DD/YYYY HH24:MI:SS'''); end;

The following exception is raised:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_SESSION", line 46
ORA-06512: at line 2

Any ideas would be greatly appreciated. TIA,

Gerard

---

Gerard M. Averill, Associate Researcher CHSRA, University of Wisconsin - Madison GAverill_at_chsra.wisc.edu Received on Mon Jul 06 1998 - 16:14:36 CDT