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).