Thursday, 14 March 2019

[Question] Getting Invalid Bind Direction for thi, ANY HELP from anyone X in here is for protection but should still be able to understand if you are a node programmer. NJS-013: invalid bind direction

NJS-013: invalid bind direction​​-------PACKAGE PROCEDURE---------PROCEDURE p_creation (XXXXXXX IN VARCHAR2,XXXX_code IN VARCHAR2,filing_date IN VARCHAR2,filing_time IN VARCHAR2,filing_XXXX1 IN NUMBER,XXXXX_ind IN VARCHAR2,enty_code IN VARCHAR2,user_id IN VARCHAR2,out_doct_seq OUT NUMBER)​------NODE JS -------ROUTESmethod: 'POST',config: {handler: WriteHandler.write,description: 'Adds information of a passed XXXXX.',notes: 'Must pass in a valid XXXXX and Sequence',tags: ['api',,'write'],//put in a different file to be reused by other routesvalidate: {params: {XXXXXX: Joi.string().trim().required().max(15).required(),dtypCode: Joi.string().trim().max(5).required(),filingDate: Joi.string().max(11).required(),filingTime: Joi.string().required(),XXXXX1: Joi.number().min(1000100).max(100000000).required(),XXXXXInd: Joi.string().trim().max(1).required()}​--------NODE HANDLER ----------var bindValues = {"XXXXX": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${ XXXX }`},"dtypCode": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${ dtypCode }`},"filingDate": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${ filingDate }`},"filingTime": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${ filingTime }`},"XXXX": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${ XXXX1 }`},"XXXXXInd": {type: oracledb.STRING, dir: oracledb.BIND_IN, val: `${xxxxxInd }`},"entyCode": 'DC',"userID": {type: oracledb.STRING, dir: oracledb.BIND_IN,val: `${ tokenCourtConnect.tokenUser }`},"result": { dir: oracledb.NUMBER, type: oracledb.BIND_OUT, maxSize: 10000 }};​let storedProcName = `XXXXXXXXXXX.CK_CREATION.p_creation(:XXXXX,:dtypCode,:filingDate,:filingTime,:XXXXX1,:XXXXXInd,:entyCode,:userID)`;dbPool.executePoolStoredProcedure(token.tokenApp, storedProcName, bindValues, function (result) {reply(result);});

Submitted March 14, 2019 at 05:00PM by laxerz

No comments:

Post a Comment