Create Stored Proc returning table

From: Masseglia <patrick.masseglia_at_renault.com>
Date: Fri, 17 Sep 1999 11:32:19 +0200
Message-ID: <37E20AA3.AFA64FDC_at_renault.com>

Hi,

[Quoted] When I try to create the following stored proc:

• PACKAGE CREATE OR REPLACE PACKAGE GLPAYS AS TYPE paystabtyp IS TABLE OF BM50_PVTE%ROWTYPE INDEX BY BINARY_INTEGER;

 PROCEDURE lire_pays (idpays IN CHAR, tab_pays out paystabtyp); END GLPAYS;
/

• PACKAGE BODY CREATE OR REPLACE PACKAGE BODY GLPAYS AS

 PROCEDURE lire_pays (idpays IN CHAR, tab_pays OUT glpays.paystabtyp) IS

  code_pays CHAR(6);
  lib_pays CHAR(20);
  recpays glpays.paystabtyp;
  CURSOR C1(idpays char) IS
    SELECT *
    FROM BM50_PVTE
    WHERE BM50ID_PVTE > idpays;
 BEGIN
    OPEN c1(idpays);
    FETCH c1 INTO recpays;
    tab_pays(1) := recpays;
    dbms_output.put_line('tabpays : ' || tab_pays(1));  END lire_pays;

END GLPAYS;
/

In order to work with a table of data instead of cursor, Oracle 8.04 Return me errors
about type mismatch beetween FETCH cursor and INTO variable. IS somebody can help me?

Patrick Masseglia.: Received on Fri Sep 17 1999 - 11:32:19 CEST