Re: Dynamic Sql Oracle VS Sql Server

But you cannot use Ref Cur in dynamic SQL.

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:vkKM6.17692$p33.324648_at_news1.sttls1.wa.home.com...
> See ref cursor in the documentation.
> "Ricky Jones" <rjones_at_hascientific.com> wrote in message
> news:3b029a07_3_at_newsfeeds...
> > Dynamic Sql Oracle Vs Sql Server 7.0
> >
> > Im currently converting a MSSql Server 7.0 database into Oracle 8i.
> > The sql server database uses the exec command to run a stored procedure,
 it
> > pulls the name from a table and runs it, it returns a result set from
 this.
> > In oracle i've tried to do the same thing with the EXECUTE IMMEDIATE
 command
> > but it does not allow using cursors as paramters. Is there any way to
> > emulate this functionality in Oracle?
> >
> >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu May 17 2001 - 16:18:32 CEST