[Forms Developer 6i] to connect a datablock to a query - stored procedure: problem

From: Gil-galad <gilgalad_at_eldar_valar.invalid>
Date: Sat, 14 Jun 2003 07:19:41 GMT
Message-ID: <h0AGa.88954$lK4.2570744_at_twister1.libero.it>

I have the following table...

CREATE TABLE I_TIPOLOGIA (

CODICE                  NUMBER(6),
DESCRIZIONE             VARCHAR2(100),

CONSTRAINT I_TIPOLOGIA_PK PRIMARY KEY (CODICE) ); and the following package to connect a datablock to previous table with a stored procedure...

[Quoted] CREATE or REPLACE PACKAGE DATABANKER_TIPOLOGIE AS

   TYPE TipTableOfRec IS TABLE OF I_TIPOLOGIA%ROWTYPE;    PROCEDURE leggi(resultset IN OUT TipTableOfRec); END DATABANKER_TIPOLOGIE; CREATE or REPLACE PACKAGE BODY DATABANKER_TIPOLOGIE AS

   PROCEDURE leggi(resultset IN OUT TipTableOfRec) AS    BEGIN

      SELECT * BULK COLLECT INTO resultset
      FROM I_TIPOLOGIA;   

   END leggi;
END DATABANKER_TIPOLOGIE; When I compile the form I receive in QUERY-PROCEDURE trigger en error 306: "number or type of arguments are wrong in POPULATE_BLOCK" I post the trigger auto generated by Forms Builder 6i...

DECLARE
   bk_data DATABANKER_TIPOLOGIE.TIPTABLEOFREC; BEGIN
   DATABANKER_TIPOLOGIE.leggi(bk_data);
   PLSQL_TABLE.POPULATE_BLOCK(bk_data, 'BLOCCO50'); -- <- error here END; How can I solve this problem? Maybe there is a bug?

P.S. I'm using Oracle Database 9i Received on Sat Jun 14 2003 - 09:19:41 CEST