Skip to Content
0
Aug 13, 2016 at 10:23 AM

Error on running procedure with input parameter in an XSJob

226 Views

Hi All,

I have a stored procedure and wish to run it with an XSjob.

The hdb procedure has 1 input parameter p_material of type nvarchar.

I get the error: Parameter mismatch. Abort.

What could be the issue here?

The XSjob runs fine when I remove parameters in the procedure and in the job file.

There's something silly in the code I wrote below and I can't seem to figure it out. Please help. Thanks!

The XS code I wrote is:

{

"description": "Demo Procedure",

"action": "<package_name>::sales_procedure",

"schedules": [

{

"description": "Run every 10 seconds",

"xscron": "* * * * * * 10",

"parameter": {

"p_material" : "Material1"

}

}

]

}

BR,

Shyam