Re: SQL Plus 3.3 disconnecting

Hello again, John.

The command that did it for me was:

WHENEVER SQLERROR EXIT FAILURE; Perhaps you will find this command or equivalent in your code somewhere, and this would tend to disconnect you when you made silly errors.

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 Fri Jul 09 1999 - 05:19:20 CEST