Is there a pre-delete trigger on the table?
> -----Original Message-----
> From: Craig Healey [mailto:c.healey_at_hhsuk.com]
> 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
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: MGogala_at_oxhp.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 - 12:16:02 CST
