Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'Fetch Out of Sequence'?

Re: 'Fetch Out of Sequence'?

From: Rangarajan Radhakrishnan <ranx_at_worldnet.att.net>
Date: 1998/03/26
Message-ID: <6ff97u$dir@bgtnsc03.worldnet.att.net>#1/1

I dont see much code but fetch out of sequence could be because of fetching from a closed cursor

Rangarajan
(Almost Anonymous)

Paul Swallow wrote:

> Can anyone see why the following program causes a 'fetch out of
> sequence' error in my outer loop 'outer1' when a user defined
> exception is raised, and handled, inside the p_validate
> procedure:
> +AAE-
> CREATE OR REPLACE PACKAGE itf_package AS
> --
> --***************************************************************
> --
> --
> -- Author: Paul Swallow
> -- Creation Date: 16/03/98
> +AAE-
> --
> -- Date Changed By Change
> -- ---- ---------- ------
> -- 16/03/1998 Paul Swallow Initial version
> --
> --***************************************************************
> *
> --
> -- -------------------
> -- Create Package Body
> -- -------------------
> --

>

> --
> ------- -------- -------
> ------- -------- -------
> ------- -------- -------
> ------- -------- -------
Received on Thu Mar 26 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US