Question Re: Problems with ConnectInit parameter in Technology Q&A

Problems with ConnectInit parameter

former_member276477 — Fri, 30 Apr 2010 10:21:36 GMT

Hi,

Iu2019m trying to use the ConnectInit setting on the Universe connection to set some Oracle session parameters, NLS_DATE_FORMAT and NLS_TERRITORY, without any success. I can set either parameter but not both at the same time. Iu2019ve tried using a semi colon delimiter, tried creating an anonymous pl/sql block and getting it to invoke an existing package without any success. Iu2019ve canu2019t find any documentation on this parameter. Running XIR2 on Oracle 10G

Any ideas?

Re: Problems with ConnectInit parameter

former_member142702 — Fri, 30 Apr 2010 12:00:10 GMT

Ensure that the configuration section of the PRM file for oracle is set as follows on the BOBJ server:

Regards,

Stratos

Re: Problems with ConnectInit parameter

former_member276477 — Fri, 30 Apr 2010 13:29:09 GMT

Hi Stratos,

I tried this without any success, same problem as before. I checked the prm file and noticed that this was already here :

I pasted in your line anyway but didn't seem to make any difference.

Cheers

Alistair

Re: Problems with ConnectInit parameter

former_member142702 — Fri, 30 Apr 2010 17:28:19 GMT

quick workaround: try to set the second session attribute by modifying the BEGIN_SQL parameter in your universe (File->Parameters->parameters).

Regards,

Stratos

Re: Problems with ConnectInit parameter

former_member276477 — Mon, 03 May 2010 07:21:23 GMT

Stratos,

Still no joy. I set the BEGIN_SQL parameter in the Universe, it accepted it okay but didn't seem to work. I wrote an ad-hoc query in WebI and the NLS_DATE_FORMAT isn't being reset. I did a quick google and i don't think BEGIN_SQL is available till 3.1, we are still on XI R2.

Thanks for your help.

Cheers

Alistair

Re: Problems with ConnectInit parameter

former_member142702 — Mon, 03 May 2010 08:29:01 GMT

Try the following command

alter session set NLS_DATE_FORMAT=XXXXX NLS_TERRITORY=YYYY

Regards,

Stratos

Edited by: Efstratios Karaivazoglou on May 3, 2010 10:30 AM

Re: Problems with ConnectInit parameter

former_member276477 — Mon, 03 May 2010 08:56:38 GMT

Stratos,

Problem solved, you are a star.

Thanks for all your help.

Cheers

Alistair