Yes, that's the problem. Thanks for the help.
Craig Healey
-Original Message-
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]
Sent: 27 February 2003 18:16
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting rows (ORA-01403)
Is there a pre-delete trigger on the table?
-Original Message-
From: Craig Healey [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Deleting rows (ORA-01403)
It's getting late, and Buffy the Vampire Slayer is on TV
tonight, so I
want to go home...sorry, I'm digressing...
I try to delete a row, in TOAD, or in SQL*Plus, and I get an
ORA-01403:
ORA-01403 no data found
Cause: In a host language program, all records have been
fetched. The
return code from the fetch was +4, indicating that all
records have been
returned from the SQL query.
Action: Terminate processing for the SELECT statement.
Help!
SELECT * FROM TABLE1
WHERE SOR_NO=1303
works fine (it returns 8 duplicate rows),
but
DELETE FROM TABLE1
WHERE SOR_NO=1303
returns ORA-01403
I expect it's something really stupid that I've forgotten,
but I just
can't see what it is.
Regards
Craig Healey
**
This email and any files transmitted with it are confidential
and intended solely
for the use of the individual or entity to whom they are
addressed and may contain
confidential and/or privileged material. Any review,
retransmission, dissemination
or other use of, or taking of any action in reliance upon,
this information by
persons or entities other than the intended recipient is
prohibited. Statements
and opinions expressed in this e-mail may not represent those
of the company.
If you have received this email in error please notify
[EMAIL PROTECTED]
This footnote also confirms that this email message has been
swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)
**
*
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Craig Healey
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Craig Healey
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).