Re: Profiler tool

afaik in oracle:

CREATE PACKAGE emp_data AS

   TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;    PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp); END emp_data;

CREATE PACKAGE BODY emp_data AS

   PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp) IS    BEGIN
         OPEN emp_cv FOR SELECT * FROM emp;    END open_emp_cv;
END emp_data;

in sql-srv:
[Quoted] create procedure emp_data as select * from emp

"wayne" <no_at_email.please.com> wrote in message news:9feffp$1er_at_dispatch.concentric.net...
> > it's possible in oracle, but it's much more complicated than in sql
 server
>
> "Much more"? How simple can a ref cursor get?
>
>
Received on Mon Jun 04 2001 - 13:53:12 CEST