Re: Newbie problem:- SQLPlus -Windows 2000 pro error

Hi,

I was running Personal Oracle8i 8.1.5 on Win2000 PRO SP2 for several months and have not encountered such problems. Have you installed the Service Packs?

I am currently running Personal Oracle8i 8.1.7 on Win2000 PRO SP2 and tried deleting a non-existent table. There was no crash.

SQL> drop table no_exist;
drop table no_exist

           *
ERROR at line 1:
ORA-00942: table or view does not exist

On 22 Jul 2001 08:59:40 -0700, mazaaak_at_hotmail.com (Shree) wrote:

>Hi,
>
>I am using Oracle 8.1.5 on Win 2000 Pro, with SQLPLUS 8.1.5.0.0
>
>I have a problem with SQLPLUS. Whenever I execute an sql that returns
>an error (e.g. dropping a table that doesn't exist), I get a windows
>popup message that says
>"
>SQLPLUS.exe has generated errors and will be closed by Windows. You
>need to restart the program.
>
>An error log is being created
>"
>
>The next thing is SQLPLUS quits. However, this does not happen if the
>SQL executes successfully.
>
>I having trouble with SQLs that potentially return error codes but it
>is okay to have an error code returned. (To be specific, I want
>running a DDL script that drops tables first before creating them.
>For the first time, dropping non-existant tables would return an
>error)
>
>Can anyone please help me?
>
>Thanks,
>Shree
  Received on Sun Jul 22 2001 - 18:40:56 CEST