SSJS + Oracle's stored proc get OutParameters

From: Patrick Masseglia <patrick.masseglia_at_renault.com>
Date: Tue, 21 Sep 1999 10:21:22 +0200
Message-ID: <37E74002.42D3D5C8@renault.com>

HI,
A problem with calling stored proc out prameters with Server Side Java Script.
When I try to get a table generated by an Oracle's stored proc, I have no information in my objetc spnobj:

My SSJS code is:

  <server>

   connobj = project.db.connection("");    spobj = connobj.storedProc("glpays.lire_pays", "01");    write(spobj.outParameters(0));
   spobj.close();
   connobj.release();

  </server>

My strored proc (wich is working in sql plus mode) is:

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

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

• PACKAGE BODY PACKAGE BODY GLPAYS AS

 PROCEDURE lire_pays (idpays IN CHAR, tab_pays IN OUT paystabtyp) IS   code_pays CHAR(6);
  lib_pays CHAR(20);
  n BINARY_INTEGER;
 CURSOR C1(idpays char) IS

    SELECT *
    FROM BM50_PVTE
    WHERE BM50ID_PVTE > idpays;
 BEGIN
    n :=0;
    OPEN c1(idpays);
    LOOP
    n := n+1;
    FETCH c1 INTO tab_pays(n);
    EXIT WHEN c1%NOTFOUND;
    END LOOP;
    CLOSE c1;
END lire_pays;
END GLPAYS; Is somebody can explain me the goog method to get an Oracle's V8.x stored proc's out parameters.
Thanks a lot,

Patrick. Received on Tue Sep 21 1999 - 03:21:22 CDT