Re: Dynamic Sql Oracle VS Sql Server

Your description of the problem seems to me to be like creating a function just so you can do something like
select * from table;

While any programming problem can be solved by adding another level of indirection why not just issue a select statement? Unlike SQLServer Oracle does not have the concurrency problems and thus you don't hav to go through such machinations just to get some data.(readers don't block writers and writers don't block readers)

Certainly there are probably ways to accomplish what you want to do , but it isn't going to be pretty and it isn't going to scale well. (Dynamic sql by its nature is not very scalable)
Jim

"Ricky Jones" <rjones_at_hascientific.com> wrote in message news:3b03dc30_3_at_newsfeeds...
> 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 Fri May 18 2001 - 02:45:51 CEST