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