XSSQLCC using $.hdb.getConnection

[SergioG_TX]

dear gurus,

I am trying to execute a stored procedure (has 1 input param) using an xssqlcc.

I am able to execute the proc correctly if i do not pass in the xssql connection configuration, however, if i include the xssqlcc, I get an error stating that my input param is not bound. I am using SP12

this works:

var conn = $.hdb.getConnection();

var myProc = conn.loadProcedure(mySchema, "myNamespace::ProcName");

myProc(input1);

this doesn't work:

var conn = $.hdb.getConnection({ "sqlcc" : mySqlCC, "pool": true });

var myProc = conn.loadProcedure(mySchema, "myNamespace::ProcName");

myProc(input1);

//dberror($.hdb.Connection.executeProcedure): 1281 - SQL error, server error code: 1281. wrong number or types of parameters in call: <INPUT_PARAM1> is not bound:

any thoughts / ideas?

[SergioG_TX · Accepted solution]

apparently a missing permission to the role assigned to the user was causing this, however, the error message was misleading saying that the error was due to an input param not being bound.

again, this is a non-issue any more.

[william_andradebatista · Accepted solution]

Yes, you´re right! I faced the same problem, in my case my procedure was performing a deletion, so I had to GRANT an object privilege, to the user as follows: GRANT DELETE ON SCHEMA "_SYS_BIC" TO "USR" and everithing worked fine after....

Regards,

Will