Yes. Remember that this type of approach is not scalable. Fine for the
occasionally called procedure, but if you are using it the majority of the
time it is very inefficient.
Jim
"Arijit Mukherjee" <arijit_at_lucent.com> wrote in message
news:3BF39E4F.D0CA5891_at_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 - 07:59:32 CST
