Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> In TOAD, how do I display refcursor results returned by an Oracle Store Procedure
I am using TOAD, and I have a simple Oracle SP that returns a cursor:
CREATE OR REPLACE PROCEDURE pObjectTypeList (
iObject nvarchar2, oResult OUT Types.RefCursor
BEGIN
OPEN oResult FOR
SELECT
* FROM ObjectType WHERE UPPER(ObjectType.Object) = UPPER(iObject)END; I can execute it successfully in TOAD as follows:
DECLARE
IOBJECT nvarchar2(200);
ISORTBY nvarchar2(200);
ORESULT Types.RefCursor;
BEGIN
IOBJECT := 'LedgerTemplateItem';
ISORTBY := 'LedgerTemplateItem';
LOAN_MOD.POBJECTTYPELIST ( IOBJECT, ISORTBY, ORESULT );
COMMIT;
END;
However, I cannot figure out how to display the contents of ORESULT in
TOAD. (The result set works beautifully in .NET using
System.Data.Oracle components.)
Eric Received on Thu Sep 16 2004 - 12:27:45 CDT