Re: SQL*PLUS BUG

In article <3970_at_oodis01.af.mil>, lew_at_oodis01.af.mil (Yee Lew) writes:
>
> The problem is that when one terminates a statement in a SQL*PLUS script
> file with a semicolon, or inserts one too many slashes, the previous SQL
> command will run twice.

This is true for the case when there are additional '/' but not so with ';' All that occurs is that the previous statement is echoed and NOT EXECUTED.

> This will also happen if you put a slash after
> a HOST command or a START command where the called script file ended with
> a slash.
>

Is this happening at your site? Did you try it out? A '/' will not re-execute
a HOST command nor will a ';'.

A '/' will execute whatever statement that is currently in your SQL*Plus buffer
and a ';' echo it.

If you are experiencing what you have just described, then it could be a bug. It
would help if you could specify your environment eg Machine and Op/system, RDBMS
Version # and Software version # eg SQL*Plus 3.0.9.1.2

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198