Oracle DB Connection parameters

building semantic layer
1

Hey guys,

I have a Universe sitting ontop of a Oracle 11i DB. I have to pass the NLS_Language to the DB, as it has to be American.

Is there any way to do this?

Cheers,

Stuart

stuartgmilton :uk: (BOB member since 2003-01-30)

2

Which is the same as your earlier post here

Having worked with BusObj and Oracle on numerous occassions I have never had to do this. Besides, if your in the UK why would you want American settings?

This also doesn’t look like a BusObj problem since you have the same problem with SQL+.

Speak with your DBA.

dessa :madagascar: (BOB member since 2004-01-29)

3

I have spoken to the DBA.

The problem is with the client side. Believe it or not, with 11i eBusiness, if you connect using NLS_LANG English, you get no data returned in certain queries. If you connect using NLS_LANG America, you get data returned.

This is a know Oracle issue, but I need to know if it is possible to set the variables in my client. In this instance Business Objects.

stuartgmilton :uk: (BOB member since 2003-01-30)

4

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Carry on in the previous topic as linked by dessa.

Nick Daniels :uk: (BOB member since 2002-08-15)