Re: Cannot pass a view name to a stored procedure as a parameter

From: Arijit Mukherjee <arijit_at_lucent.com>
Date: Thu, 15 Nov 2001 16:21:59 +0530
Message-ID: <3BF39E4F.D0CA5891@lucent.com>

Hi,

I was able to do this using dynamic sql. Oracle 8i supports NDS (Native Dynamic SQL), which makes life quite OK for this sort of requirements. However, if you are using Oracle 8 or lower, you could use the DBMS_SQL package to do the same,
Regards,
Arijit

Arijit Mukherjee wrote:
>
> Hi,
> I am using Oracle 8 and need to pass a view name to a stored
> procedure. I tried passing the name as varchar2. However, when I try to
> use this string inside a query (be it inside a cursor or inside the
> executable block inside the stored procedure), I get a compilation error
> - saying that this varchar2 variable is undefined.
> Is there any way I can do this?
> Any help is highly appreciated,
> Regards,
> Arijit
Received on Thu Nov 15 2001 - 04:51:59 CST