Skip to Content
0

XSSQLCC using $.hdb.getConnection

Aug 21, 2017 at 03:51 PM

128

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Sergio Guerrero Aug 23, 2017 at 03:38 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

1