Re: Parameterized Ref Cursor

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 02 Jul 2005 14:03:08 +0200
Message-ID: <ch0dc1poc3kp6jql02tjoj6idq3428sif5@4ax.com>

On 2 Jul 2005 04:50:03 -0700, "Meenu" <meenu.desai_at_gmail.com> wrote:

>Hi,
>
>Is it possible to implement a "PARAMETRIZED REF CURSOR" in Oracle? How?
>
>Can I use "TYPE My_Cur(P_NAME VARCHAR2) IS REF CURSOR;" in Oracle?
>
>Thanks in advance,
>Meenu.

No, you can't
This is not a problem as you can use bind variables in your dynamically set up statement.
just use
open cv for
'select * from emp where empno =:1' using p_empno;

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jul 02 2005 - 07:03:08 CDT