Append set command to the query

[system]

This topic shows a conversation about using ConnectInit to set some initial parameters:

120×120 10.4 KB

Hi all, My question resides around whether or not it is possible within Designer to automatically set the NLS values at execution of a query. I need to set the following values every time a query is run over a specific database: dbms_application_info.set_client_info(906); execute immediate 'alter session set nls_language="AMERICAN"'; Is it even possible to do this and if so how. The one thing I don’t want to do (and I don’t even know if this would work) is to create a dimension in the unive…

---

Dave Rathbun (BOB member since 2002-06-06)