Home » RDBMS Server » Server Administration » about return
about return [message #370042] Tue, 05 December 2000 02:57 Go to next message
chuah
Messages: 4
Registered: December 2000
Junior Member
how can i return a dataset from a procedure?

Report message to a moderator

Re: about return --here is how [message #370055 is a reply to message #370042] Thu, 07 December 2000 06:52 Go to previous message
vasanth Kumar
Messages: 3
Registered: December 2000
Junior Member
CREATE PACKAGE emp_data AS
TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;
END emp_data;

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

-- Then from SQL*PLUS call procedure as
SET AUTOPRINT ON
VARIABLE cv REFCURSOR
EXECUTE open_emp_cv(:cv);

Report message to a moderator

Previous Topic: Dynamic SQL and Ref Cursor
Next Topic: Encryption and Decryption
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 19:47:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.