Re: Newbie sp_ Question

REF CURSOR doesn't tell me anything and this is the last thing that I would consider as a solution to my problem.
There are some standards on the market today. If Oracle develop new tech then they should at least make some remarks in their publication about
the differences etc. - most of the DBAs have experience with SYBASE and we learn new tech in comparison to that what we have already learned - whether you like it or not. They simple force people to learn everything from the scratch, which will discourage many people from using their software.

Thanks anyway.

P.S. is temporary table feature added to new 8i v. the result of their (Oracle) bright technology?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:969715079.8598.1.pluto.d4ee154e_at_news.demon.nl...
> I'm amazed by this.
> It definitely is covered under REF CURSOR.
> Also you could look at http://osi.oracle.com/~tkyte/Resultsets.
>
> IMO, (as response to you more or less condescending remarks about
> documentation), I don't understand why sqlserver types use stored
 procedures
> for even very simple selects. That is definitely unnecessary.
> In short, you should try to learn the *oracle perspective* and put aside
> your sqlserver or sybase habits. Otherwise you will end up with code that
> from the Oracle perspective is very inefficient.
>
> Oracle is not sqlserver nor sybase, it's much better than that.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Lee J." <ljeznach_at_csi.com> wrote in message
> news:jMPy5.5498$dZ2.1382333_at_news3.rdc1.on.home.com...
> > I have an Oracle 8i Reference and PL/SQL Programming books (ORACLE
 Press)
> > and I couldn't find anything that would deal with stored procedures that
> > return a sample record set.
> > Very basic problem from MS SQL or SYBASE prospective, which is not
 covered
> > by any of the books, mentioned above.
> > If any of you guys know a good book dealing with sp properly then I very
> > appreciate your email.
> > Sample code is very welcome.
> > Lee.
> >
> >
> >
>
>
Received on Sat Sep 23 2000 - 14:13:03 CDT