Re: Dynamic Sql Oracle VS Sql Server

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Thu, 17 May 2001 06:37:15 GMT
Message-ID: <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! =-----
Received on Thu May 17 2001 - 08:37:15 CEST

Original text of this message