Re: Migration from SQL-Server 7.0

This is the usual disease, which can be remedied by a prescription of RTFM. or consulting
http://osi.oracle.com/~tkyte/ResultSets/index.html as has been posted _many many_ times in this newsgroup.

Also, you are comparing a recent version of sqlserver to a version of Oracle which goes out of support soon. The current version is Oracle 8i and your second example is possible using 8i.

My experience is people with a sqlserver background are expecting everything to function in Oracle _exactly_ the same way, and they start complaining about Oracle immediately when this doesn't proof true. Of course they just started 'somewhere', which is usual in the Microsoft world. So that's why my orginal last sentence was a bit cynical.

Regards,

Sybrand Bakker, Oracle DBA

"Jan-Erik Rosinowski" <spamfilter_at_rosinowski.de> wrote in message news:38f41594.21380032_at_News.CIS.DFN.DE...
> >False, Oracle does return resultsets.
> >Maybe your a better off with sqlserver.
>
> my english is not good enough to understand what your last sentence
> really ought to tell me. anyway:
>
> create procedure retset as
> begin
> select * from dual;
> end;
>
> gives me a pls-00428 using ora 7.3.4. so what?
>
> another tsql feature where i'm looking for a reasonabe translation:
>
> tsql:
>
> if exists(select * from foo where key='bar')
> ...
>
> plsql:
>
> declare excount number;
> select count(*) into excount from foo where key='bar';
> if excount>0 then
> ...
>
>
> ciao, jan
>
> http://www.rsp.de/
>
> rs&p-Dossier: Software zur Erstellung technischer Dokumentationen
> und Schriftgutes in Verwaltung und Industrie.
Received on Sat Apr 08 2000 - 00:00:00 CDT