Oracle-L: Deleting rows (ORA-01403)

From: Craig Healey <c.healey_at_hhsuk.com>
Date: Thu, 27 Feb 2003 09:24:30 -0800
Message-ID: <F001.0055BC18.20030227092430@fatcity.com>

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 system.administrator_at_hhsuk.com

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: c.healey_at_hhsuk.com

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: ListGuru_at_fatcity.com (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). Received on Thu Feb 27 2003 - 11:24:30 CST