We Recommend

SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Posted By

rengber on 07/25/06

Tagged

Oracle PLSQL StoredProc

Versions (?)

Oracle Stored Proc to Return a Recordset (Oracle Side)

Published in: SQL

Plain TextExpand

CREATE OR REPLACE PROCEDURE RobCursorTestProc
(
  my_cursor IN OUT SYS_REFCURSOR
)
AS
BEGIN
  OPEN my_cursor FOR
    SELECT  TABLE_NAME,
            OWNER				
    FROM ALL_TABLES;
END;
SHOW ERRORS;

Report this snippet

Comment:

You need to login to post a comment.

We Recommend

Posted By

Tagged

Versions (?)

Oracle Stored Proc to Return a Recordset (Oracle Side)

Choose a language for easy browsing: