Problem setting nls_calendar via DBMS_SESSION.SET_NLS

I have a question about using
the DBMS_SESSION.SET_NLS procedure. I need to set nls_calendar to Japanese Imperial and then change it back to Gregorian. I have no problems doing this in SQL:

alter session set nls_calendar = 'Japanese imperial';

This works fine. However, the following statement in PL/SQL (I want to create a stored package to do this) causes an error..

dbms_session.set_nls('nls_calendar','japanese imperial');

this produces the following error:
ORA-02248: invalid option for ALTER SESSION ORA-06512: at "SYS.DBMS_SESSION", line 52

I presumed there was a syntax problem, except that the following statement does not produce an error:

dbms_session.set_nls('nls_calendar','gregorian');

After a little experimenting, the only parameter that seems to work when setting nls_calendar via set_nls is 'gregorian'.

Am I missing something obvious? How do I use DBMS_SESSION.SET_NLS to set international calendars?

Thanks in advance!

Daniel

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Aug 19 2000 - 21:13:15 CDT