Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_sql help
...
Besides,
I see that there is a problem
to declare a function that use dbms_sql ,
because oracle enforce me to declare :
restrict_references(myfunc, WNDS, WNPS)
for that function (if I want to use it in an sql statement),
I want to use it externally within sql statement.
something like :
select my_package.my_sql_func ... from dual;
How can I overcome that problem ?
Thanks :)
"Eitan" <no_spam_please_at_nospam_please.com> wrote in message
news:dup47n$7v7$1_at_news2.netvision.net.il...
> Well,
> I didn't know about execute immediate.
> (Is it simplier ? any sample , please).
> (for oracle 8i and greater).
>
> Thanks :)
>
> <frank.van.bortel_at_gmail.com> wrote in message
> news:1141901693.749483.317300_at_v46g2000cwv.googlegroups.com...
> > http://www.psoug.org/reference/dbms_sql.html
> >
> > I wonder why you need dbms_sql as there is execute immediate
> > Unless you are on an old version of Oracle, of course...
> >
> > Which is why I prefer you would make it a habit of posting your
> > envrionment and oracle version (as simple as 9iR2 on Win2000)
> >
> > Regards,
> > Frank van Bortel
> >
>
>
Received on Thu Mar 09 2006 - 05:59:09 CST