Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

xsjob error :how to pass input parameters to stored procedure call from .xsjob

Error : SQL exception 1281: wrong number or types of parameters in call: IN_KEY_DATE is not bound: line 1 col 6 (at pos 5) at ptime/query/checker/check_call.cc:505

My  xsjob

{

  "description": "My first SQLScript job",

  "action": "XXXX::XXXX" ,

 

  "schedules":

  [ {

    "description": "Will run every 59 seconds",

      "xscron": "* * * * * *  59" ,

      

   "parameter" : { "IN_KEY_DATE" :"20150715",

                    "VALUE1" :"1" ,

                    "VALUE2" : "ABC"

                    }

  

     }

    

      ]

      }

It works if I Call "_SYS_BIC"."xxx/procedure" ('20150715' , '1' , 'ABC');

If I schedule a job for other procedure without input parameters it works but now I have my new procedure with 3 input parameters

Tags:
Not what you were looking for? View more on this topic or Ask a question