Re: Stored Procdure Returning Ref Cursor
From: Brian Neary <bneary_at_gnosis-is.com>
Date: Mon, 27 Sep 1999 10:40:30 -0700
Message-ID: <6bOH3.21$pp6.192039_at_news.bctel.net>
END; Paul Dorsey wrote in message ...
>Look in the help system. There is one there.
>
>--
>Paul Dorsey
>Dulcian, Inc.
>www.dulcian.com
>212 595 7223
>P.S.
>If you would like to talk to Dulcian about a salaried position on our team,
>please call me.
>We have openings in NJ for developers, in CA for PERL developers.
>
>Brian Neary wrote in message ...
>>I'm using Oracle8i and Forms 5.0. I want to create a block in my form
>based
>>on a stored procedure. The stored procedure needs to return a REF CURSOR.
>>I'm looking for an example of DDL used to create a stored procedure that
>>returns REF CURSOR.
>>Thanks Brian
>>
>>
>
>
Received on Mon Sep 27 1999 - 19:40:30 CEST
Date: Mon, 27 Sep 1999 10:40:30 -0700
Message-ID: <6bOH3.21$pp6.192039_at_news.bctel.net>
I'm using the data block wizard in Forms 5.0. When I base my block on a procedure that returns a ref cursor the only type of argument I get is the cursor name of type RefCursor and I don't get any "Available Columns". How do I get the columns returned by the cursor to show in the data block wizard? Do I need to change my procedure?
package types
as
[Quoted] type CursorType is ref cursor;
end;
PROCEDURE BRIAN_PO_DOCS_CURSOR (C2 IN OUT types.CursorType) as
BEGIN
OPEN C2 for SELECT *
FROM PO_DOCS , PO_ITEMS WHERE PO_DOCS .PO_DOC_ID =
PO_ITEMS .PO_DOC_PO_DOC_ID;
END; Paul Dorsey wrote in message ...
>Look in the help system. There is one there.
>
>--
>Paul Dorsey
>Dulcian, Inc.
>www.dulcian.com
>212 595 7223
>P.S.
>If you would like to talk to Dulcian about a salaried position on our team,
>please call me.
>We have openings in NJ for developers, in CA for PERL developers.
>
>Brian Neary wrote in message ...
>>I'm using Oracle8i and Forms 5.0. I want to create a block in my form
>based
>>on a stored procedure. The stored procedure needs to return a REF CURSOR.
>>I'm looking for an example of DDL used to create a stored procedure that
>>returns REF CURSOR.
>>Thanks Brian
>>
>>
>
>
Received on Mon Sep 27 1999 - 19:40:30 CEST