Hi,
I am getting below error while running. proc with node
[Error: ORA-01036: illegal variable name/number] {
** errorNum: 1036,**
** offset: 0**
}
below proc execute successfully in SQL terminal and return 1 after sucess.
// `SET SERVEROUTPUT ON;
// DECLARE
// i_user_name fw_user.username%TYPE := NULL;
// l_true BOOLEAN := true;
// BEGIN
// FW_GLOBAL_P.SESSION_ID := 'SESSION_ID';
// FW_GLOBAL_P.USER_ID := 1005;
// FW_GLOBAL_P.Language:= 0;
// l_true := mt_eets_cust_p.terminate_ttt_username(:i_user_name, l_true);
// --commit;
// DBMS_OUTPUT.PUT_LINE(sys.diutil.bool_to_int(l_true));
// END; /`
try {
conn = await oracledb.getConnection();
let result: any;
result = await conn.execute(statement, binds, opts);
console.log('result==>',result);
resolve(result.outBinds);
} catch (err) {
console.log('Inside CopySimplePlsqlExecute Error==>',err);
reject(err);
} finally {
if (conn) { // conn assignment worked, need to close
try {
await conn.close();
} catch (err) {
console.log('errror',err);
}
}
}