NLS and packages (General oracle question)

[jpickup]

When oracle executes stored procedures (or procedures in packages) it does so using the NLS settings of the client making the call.

This is often a good thing.

I have a situation where I would like to define the settings that will be used for a stored procedure (i.e. fix the character set, decimal point character, date format, etc), regardless of the settings of the caller.

Is there any way of doing this?

ALTER SESSION is able to do this but of course you can't do that in a procedure.

Thanks,
John.

(What I'm hoping is that someone says there is a PRAGMA I can use for the package...!!!)

 

[jpickup]

FYI, got a response to this on comp.databases.oracle.server
if anyone is interested, here it is:

You CAN fix decimal point character and date format calling in PL/SQL (Oracle 8.1.x)

EXECUTE IMMEDIATE 'ALTER SESSION SET nls_numeric_characters = ''.,'''
| | 'nls_date_format=''FXDD-MON-YYYY''';

Unfortunately you CAN NOT fix the character set

Valery Yourinsky
--
Oracle8 Certified DBA
Moscow, Russia

[This message has been edited by jpickup (edited 26 January 2001).]

 

[Marco Kalter]

In prvious Oracle Server versions you can also use the dbms_session.set_nls procedure.

------------------
Marco Kalter
Allround Automations