title: How run a stored procedure present in SQL Developer from a Control-M database job with Execution type as embedded query
body: <p>I am new to Control-M scheduling and the scenario I have at hand is like below:</p>
  <p>There is a stored procedure in SQL DEVELOPER which creates subpartition queries on a table. Now I need to schedule a Control-M job which runs this stored procedure directly into the database and schema mentioned in the controlM job parameters. I was able to set up the database connection part and with the Execution type as embedded query I wrote the SQL statement:    <strong>EXEC &lt;procedure_name&gt;;</strong></p>
  <p>The Control-M job is failing with ORA00900: invalid SQL statement.</p>
  <p>Note: the procedure doesnot have any partition. Also when I run the same query in SQL developer it runs successfully giving the expected result. The issue is with execution from Control-M job.</p>
  <p>Can anyone please help with the solution. Many thanks!</p>