Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'Fetch Out of Sequence'?
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
> --
> ------- -------- -------
> ------- -------- -------
> ------- -------- -------
> ------- -------- -------