Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Forms block based on stored procedure

    I'm working with Forms [32-bit] ver 6.0.8.23.2.

    I want base forms block stored on procedure:

    PROCEDURE pgs_test_blok
    (tabela IN out pgs_test_pakiet.faktura_tab_typ)

    IS
    BEGIN

    DECLARE

    CURSOR C_faktury IS
    SELECT *
    FROM LHS_faktury;

    r_faktury c_faktury%ROWtype;

    BEGIN

    open C_faktury;
    loop

    fetch C_faktury into R_faktury;
    exit when C_faktury%notfound;
    tabela(R_faktury.id).numer := R_faktury.numer;

    END LOOP;
    CLOSE C_faktury;

    END;

    END;

    Type faktura_tab_typ is defined into package pgs_test_pakiet:

    package
    pgs_test_pakiet is

    Type faktura_tab_typ is Table of lhs_faktury%rowtype
    INDEX BY BINARY_INTEGER;

    end;


    During compilation I has error FRM-30434 - The table argument in the procedure definition should have a type name.

    What does mean ?

  2. #2
    Join Date
    Dec 2003
    Location
    ha noi
    Posts
    24

    Re: Forms block based on stored procedure

    Hi,
    I am a junior Developer Ora form 9i , and I don't know what is the best purpose of using Block based on Stored Procedure, could you show me the purposes and how to build a stored procedure for this purpose.
    Give me an example if posible.

    Thank you very much!
    hdninte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •