REF CURSOR

From: <dvsingh1_at_my-dejanews.com>
Date: Mon, 31 Aug 1998 12:15:20 GMT
Message-ID: <6se44o$3c2$1@nnrp1.dejanews.com>

Hi,

I am having a trouble compiling a function containing REF CUROSR declation.

I am using REF CURSOR to open a cursor associted with a query on one field. The cursor name is associated with around 5 queries , the only diff being the field name queried. Now When I try to install / compile this function , it gives an INVALID TYPE error., actual o/p is given below.....

Package created.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY BVAPI_NEWC:

LINE/COL ERROR

-------- -----------------------------------------------------------------
0/0      PLS-00707: unsupported construct or internal error [2601]
0/0      PL/SQL: Compilation unit analysis terminated

SQL> Please help me out ......Thanks in Advance.....

D.V.Singh

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 31 1998 - 07:15:20 CDT