Re: Error on v_CursorID := DBMS_SQL.OPEN_CURSOR ?

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 - 07:27:20 CST