Toad World® Forums

Script to End Connection in TOAD Automation


#1

I need to automate via script ending connection to database between Create Table actions in my Automation App. I get a script error “ORA-02394: exceeded session limit on IO usage, you are being logged off”. I noticed that if I run each Create Table actions one at a time that they Complete just fine. I need the App to do both Create Tables back to back via scheduled automation.

I’m thinking if the App can run one create table, then end connection, then the 2nd create table will start a new connection automatically


#2

AFAIK, your ORA comes from db profile settings that your connection has. It has nothing with Toad. Please contact your DBA for that.

I noticed that if I run each Create Table actions one at a time that they Complete just fine.
what do you mean by this? Please explain

Session disconnection may be performed from sqlplus as statement:

disco;

Brg
Damir Vadas