Dynamic Sql Oracle VS Sql Server

From: Ricky Jones <rjones_at_hascientific.com>
Date: Wed, 16 May 2001 11:23:55 -0400
Message-ID: <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 Wed May 16 2001 - 17:23:55 CEST

This message: [ Message body ]
Next message: Sue Sabol: "Re: Need Your Advice"
Previous message: Ken North: "Call for speakers for iFive SQL Summit closes June 4"
Next in thread: Jim Kennedy: "Re: Dynamic Sql Oracle VS Sql Server"
Reply: Jim Kennedy: "Re: Dynamic Sql Oracle VS Sql Server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message