Setting session information

I’m sure I’ve seen something about this somewhere, but exhaustive searches have
not unearthed it, so apologies if this is asking the obvious or previously

I need to be able to set session information when opening a connection. A lot of
my work is in Oracle Financials, and without setting NLS_LANGUAGE and the org_id
using a SET_POLICY_CONTEXT statement, queries have a tendency to return nothing.
I can run a script in an editor window, but it seems to need to be run in every
editor tab to work for that tab, and this gets a bit tedious. However, not all
my work is on the Oracle Financials, so I don’t want to execute this on Toad

Is there a way I can achieve this?



This Email is confidential and intended solely for the use of the individual to
whom it is addressed. If you are not the intended recipient, be advised that
you have received this email in error and that any use, dissemination,
forwarding, printing or copying of the email is strictly prohibited.

If you have received this email in error please notify London Borough of Bexley
telephone on +44 (0) 20 8303 7777.

Web Site:

This message has been scanned for malware by Websense Inc.


What about modifying login.sql or glogin.sql?