Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Batch SQL hangs on locked row

RE: Batch SQL hangs on locked row

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 16 Mar 2001 13:14:15 -0800
Message-ID: <F001.002CF494.20010316104553@fatcity.com>

Also I'll mention that the situation would be different for a SQL statement e.g. select, insert, update, delete. In that case if the statement were terminated with a semi-colon AND the following line contained a slash then the statement would be executed twice.

Jacques R. KilchoŽr
x8816

> -----Original Message-----
> From: Paul Baumgartel [mailto:PaulB_at_instipro.com]
>
> The semicolon denotes the end of the anonymous block and the
> slash executes
> it, so it's not executing twice.
>
> -----Original Message-----
>
> I just noticed the "/" at the end of this sql that is run
> from a scheduled
> batch job.† It seems to me that this may cause the sql to
> execute twice.
Received on Fri Mar 16 2001 - 15:14:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US