0
votes

I've developed a stored procedure in oracle db and it takes three 2d array arguments. I need to use this stored procedure from my NodeJS app .

Here is my stored procedure

CREATE OR REPLACE PROCEDURE PROCED_UPDATE_APP_FORM_STRUCT
         (sections IN 2dArrayType, subSections IN OUT 2dArrayType, fields IN OUT 2dArrayType)
       IS
                 //some code

        
       BEGIN
                // I want to use above parameters here, and I need to pass those prams from a NodeJS app.
 

       END; 
  1. How can I create a 2d array type in PLSQL to accept 2d array value
  2. How can I call this procedure from NodeJS app with arguments

I welcome all of your answers for this matter

(i) read the node-oracledb manual particularly oracle.github.io/node-oracledb/doc/api.html#plsqlcollections and the following section. (ii) Update your question with the SQL statement that creates 2dArrayType - Christopher Jones