Re: Using REF cursor in method 4 of dynamic SQL

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 30 Nov 2006 00:27:24 +0000
Message-ID: <p39sm2dmnfn9l7knaqcls36lb1cf2o8bk3@4ax.com>

On 29 Nov 2006 12:29:10 -0800, muthukumarenk_at_aetna.com wrote:

>IS it allowed to use REF cursor in method 4 of dynamic SQL ?

As far as I'm aware it's not possible; DBMS_SQL (as used in Method 4) doesn't support REF_CURSOR. It uses its own cursor identifier system that only works with DBMS_SQL. Which is a bit of shame really.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Wed Nov 29 2006 - 18:27:24 CST