RE: Deleting rows (ORA-01403)

Yes, that's the problem. Thanks for the help.

Craig Healey

> -----Original Message-----
> From: Gogala, Mladen [mailto:MGogala_at_oxhp.com]
> 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: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).
>
>

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