Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to initialize Language

CarolinFeb 25 2011 — edited Feb 28 2011
Hi All,

can anybody help with how to initialize the Language when executing a query on a table that checks USERENV('LANG')?
I tried to execute a query on table MTL_SYSTEM_ITEMS_VL within SQL Developer - but I didn't get any entries...
Generally - how to set the language when calling a PL/SQL API that requires USERENV('LANG') from outside e.g. via JDBC?

Best Regards,
Carolin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2011
Added on Feb 25 2011
2 comments
571 views