Re: Newbie sp_ Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Sep 2000 12:59:28 +0200
Message-ID: <969715079.8598.1.pluto.d4ee154e@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 - 05:59:28 CDT