Hello,
I am trying to execute proce using Node js getting below Error.
[Error: ORA-01036: illegal variable name/number] { errorNum: 1036, offset: 0}
Below proc works fine in SQL Developer terminal and return 1 after successful execution.
// `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; /`
Here is my code
