# Setting session information

**URL:** <https://forums.toadworld.com/t/setting-session-information/10085>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 3, 2010, 9:13am UTC](https://forums.toadworld.com/t/setting-session-information/10085 "2010-12-03T09:13:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ian.taylor\_000](https://avatars.discourse-cdn.com/v4/letter/i/ea5d25/32.png) [@ian.taylor\_000](https://forums.toadworld.com/u/ian.taylor_000)\
**Post date:** [December 3, 2010, 9:13am UTC](https://forums.toadworld.com/t/setting-session-information/10085/1 "2010-12-03T09:13:47Z")

</div>

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  
stated…

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  
start-up.

Is there a way I can achieve this?

Thanks.

Ian

* * *

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  
by  
telephone on +44 (0) 20 8303 7777.

Web Site: [http://www.bexley.gov.uk](http://www.bexley.gov.uk)

This message has been scanned for malware by Websense Inc. [www.websense.com](http://www.websense.com)

---

<div class="post-metadata">

**Author:** ![christopher.tryonhat](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/christopher.tryonhat/32/139_2.png) [@christopher.tryonhat](https://forums.toadworld.com/u/christopher.tryonhat)\
**Post date:** [December 3, 2010, 9:37am UTC](https://forums.toadworld.com/t/setting-session-information/10085/2 "2010-12-03T09:37:23Z")

</div>

Ian,

What about modifying login.sql or glogin.sql?

Chris