Re: Migration from SQL-Server 7.0

>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