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;
- How can I create a 2d array type in PLSQL to accept 2d array value
- How can I call this procedure from NodeJS app with arguments
I welcome all of your answers for this matter