Re: Help: OWA replacement catridge
Date: Tue, 04 Aug 1998 20:33:11 GMT
Message-ID: <35c86e98.6537600_at_192.86.155.100>
A copy of this was sent to cbarron2_at_my-dejanews.com (if that email address didn't require changing) On Tue, 04 Aug 1998 19:27:28 GMT, you wrote:
>I am using the OWA replacement catridge with Oracle Web Application Server
>3.0.1 running on Solaris 2.6. The database version is 7.3.4 (Digital UNIX).
>Everything seems to be working OK except for one feature that workd with the
>PL/SQL cartidge that comes with OWAS3.0.
>
>My problem is that the replacement cartridge does not appear to be able to
>set the database session language with the owa_nls_lang parameter in the
>owa.cfg file. When I connect with my FRENCH DCD, the database session
>language remains AMERICAN_AMERICA instead of FRENCH_CANADA. I have included a
>copy of my owa.cfg file below.
>
Yes, this is true. I can only use one NLS language setting (you can set the environment variable NLS_LANG to the one you want before starting the WRB and I'll use that one).
The problem is, I use v7 OCI. Once we load up OCI (make OCI calls) the NLS libraries are initialized and I cannot de-initialize them to use a different language. Since cartridges are persistent, once I startup and use OCI, my language is fixed until I exit and start again... I don't even bother looking at the NLS setting in the OWA.CFG, i just use the default NLS settings on your machine (overrideable with NLS_LANG in the environment of course)
The only way to use >1 language with my cartridge is to not use the cartridge but to use the cgi-bin version of it. You would set up a small shell script that set the NLS-LANG environment variable you wanted and then exec'd the owarepl binary (cgi-bin version, not owarepl.so).
The 'real' pl/sql cartridge uses a much lower level API to the database, one that I do not use... It can 'uninitialize' the NLS layer and perform this trick. I cannot...
[owa.cfg snip'ed]
>
>
>
>Thanks in advance,
>Chris Barron
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Aug 04 1998 - 22:33:11 CEST