Re: SQL Plus 3.3 disconnecting

Hi, John.

You may have a statement somewhere (in login, glogin, another script that is run, etc.) that has something like "ON SQLERROR DISCONNECT" or some such. I ran into this once while running some queries from Oracle that HAD this statement. Their queries ran fine, and then this statement killed my session later when I made silly little mistakes.

I'll see if I can find the exact statement when I get in to work tomorrow. I couldn't find anything like it with 'SHOW ALL' at the SQL Prompt. Maybe you can (since it seems to be active for you now).

Chris

"John P. Early" wrote:

> I'm running SQL Plus 3.3 under AIX and also under Windows 98 via
> SQLNet. Whenever I make the slightest error (i.e., mistype a column
> name in a select) under Windows I get disconnected from the database and
> I have to "conn username/password" before I can continue working. Under
> AIX this is never a problem. My question is, is this just a "feature"
> of SQL Plus and SQLNet, or is there something I can do so I don't keep
> getting disconnected? I realize the simple solution is to do all my
> work under AIX, but unfortunately my coworkers insist on saving .sql
> files on our Novell network which makes it kinda annoying to get them to
> the AIX machine.
>
> advaTHANKSnce,
> John.
>
> --
> John Early jpe1_at_lehigh.edu x85066
> Senior Programmer, Enterprise Systems Implementation
> Lehigh University, Bethlehem, Pennsylvania
> qotd: "Whereof one cannot speak, thereof one must be silent."
> (Wittgenstein)
Received on Wed Jul 07 1999 - 21:53:40 CEST