Skip to Content

XSSQLCC using $.hdb.getConnection

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");


this doesn't work:

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

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


//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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 03:38 PM

    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.

    Add comment
    10|10000 characters needed 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....