Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Stored Procedure as Data Source

Re: Stored Procedure as Data Source

From: Jørn Hansen <jorn-asko_at_sstofasnets.dk>
Date: Tue, 05 Oct 2004 22:09:50 +0200
Message-ID: <4162ff8a$0$14230$ba624c82@nntp02.dk.telia.net>


I don't think you can use a record as out parameter. Try to add a type

TYPE XXP_PURCHASE_SUM_TT IS TABLE OF XXP_PURCHASE_SUM_T; And use that one instead.

/Jørn
Iceman wrote:
> Hi everybody
>
> I wrote a stored procedure to use it as a source for a "Data Block" in
> a form
>
> The procedure specification is as follows:
>
> -------------------------------------------
> PACKAGE XXP_PURCHASE_SUM
> IS
>
> TYPE XXP_PURCHASE_SUM_T IS RECORD
> ( header_id number
> , po_number number
> , order_date date
> );
>
> type PURCHASE_H_Rec_Type is ref cursor return XXP_PURCHASE_SUM_T;
>
> PROCEDURE XXP_PURCHASE_SUM_P (
> param2 IN OUT PURCHASE_H_Rec_Type);
>
>
>
> END;
> -------------------------------------------
>
>
> The procedure body is as follows:
>
> -------------------------------------------
> PACKAGE BODY XXP_PURCHASE_SUM
> IS
>
> procedure XXP_PURCHASE_SUM_P
> ( param2 IN OUT PURCHASE_H_Rec_Type)
> IS
>
> PURCHASE_H_Rec_Type_Cursor PURCHASE_H_Rec_Type;
> BEGIN
>
> OPEN PURCHASE_H_Rec_Type_Cursor for select 1, 3, sysdate from dual;
> END;
>
> END;
>
>
> -------------------------------------------
>
> When I'm designing the form everything is going ok the wizard is able
> to recognize the fields and I'm able to put them on a canvas, but when
> I run the form and try to do execute query to list the records the
> form simply disappear with the Oracle Forms Runtime window without any
> error or message.
>
> Can someone help me please???
>
> Thanks
Received on Tue Oct 05 2004 - 15:09:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US