Re: Error on v_CursorID := DBMS_SQL.OPEN_CURSOR ?

Thomas,

You were correct, the problem was in the code constructing the dynamic sql statement. I must have stuffed up when I was placing my debug raise errors.

Thanks, David.

Thomas Kyte wrote:

> A copy of this was sent to David Pattinson <dpattinson_at_enternet.com.au>
> (if that email address didn't require changing)
> On Mon, 29 Nov 1999 18:44:27 +1100, you wrote:
>
> >All,
> >
> >I get the following error when attempting to execute my stored procedure
> >which contains the line "v_CursorID := DBMS_SQL.OPEN_CURSOR;"
> >I have declared v_CursorID as INTEGER.
> >
> >ERROR at line 1:
> >ORA-01001: invalid cursor
> >ORA-06512: at "DBMS_SYS_SQL", line 480
> >ORA-06512: at "DBMS_SQL", line 19
> >ORA-06512: at "DAVID.SP_POPULATE_DEFAULT_GROUP", line 55
> >ORA-01403: no data found
> >ORA-06512: at line 1
> >
> >Any Ideas? I tried qualifying DBMS_SQL with SYS, but it made no
> >difference. I'm certain this is the offending statement as I've isolated
> >it using raise error.
> >
>
> post the code for david.sp_populate_default_group. I doubt the
> dbms_sql.open_cursor is the cause of this (lets see what line 55 is --
>
> select text from user_source where name = 'SP_POPULATE_DEFAULT_GROUP' and line =
> 55;
>
> >Thanks, David.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Mon Nov 29 1999 - 21:48:28 CST