Re: Return Multi rows by cursor

[Abdullah Alharbi]

I need to passed CURSORS as out parameters same this in oracle
--------------------------
CREATE OR REPLACE Procedure AFAQ.SE_ACC_NAME
( rec out MYPKG.CursorType)
AS
BEGIN
open rec for 'select "acc_id","acc_name" from "ACCOUNTS" where "acc_parent" = 14';
END SE_ACC_NAME;
----
CREATE OR REPLACE PACKAGE AFAQ.MYPKG IS
TYPE CursorType IS REF CURSOR;
END;
---------------------------

Thank You



Edited 1 time(s). Last edit at 01/26/2009 01:52PM by Abdullah Alharbi.