Re: errors while fetching...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Apr 2000 15:02:30 +0200
Message-ID: <955039515.4286.1.pluto.d4ee154e@news.demon.nl>

without looking at the code this is almost impossible to tell. Usually this error occurs while performing a select into which doesn't trap 1403.
In all other cases this should be impossible, or the code is unstructured, and multiple fetches are being made in the same loop.

Hth,

Sybrand Bakker, Oracle DBA

<petervanhoecke_at_my-deja.com> wrote in message news:8cho66$b86$1_at_nnrp1.deja.com...
> Hello,
>
> this is the error I receive when performing selects in a loop of
> fetches.
> Can anyone give me more info on this problem, or even offer a solution?
>
> you can send the replies to dominic.steur_at_belgacom.be
>
> Thanx.
> ----------------------------------------------------------------------
> ORA-01403: no data found
> ORA-06512: at "IMD_APPLICATION.IDMS_UPLOAD", line 109
> ORA-06512: at line 2
> Program terminated with errors
>
> 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.
>
> ----------------------------------------------------------------------
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Apr 06 2000 - 08:02:30 CDT