title: running object created by DBMS_SCHEDULER.create_program
body: <p>I had an issue with DBMS_SCHEDULER in oracle.I have an external programme(a perl script residing on the server on which oracle is running) which I want to run from my stored  procedure based on certain condition.So for that I learned that an external program can be run by creating DBMS_SCHEDULER.create_program.So I did only that.Now the issue,I have a program object created in oracle and but I am unable to execute this object.I have been trying some thing like this to run this object:</p>
  
  <p>EXECUTE MY_PROGRAM_OBJECT;</p>
  
  <p>But every time I do this it is saying that object MY_PROGRAM_OBJECT is invalid(FYI...I can see this object using select * from ALL_OBJECTS).Now I sincerely think that there must be some other way to run this.unfortunately,I don't seem to find any formal doc. for a running a crated Program object.Now can u plz advice me how it needs to be executed?Is it that for executing I have to create another job and point it from there,for which I dont see any rational.</p>
  
  <p>P.S. I have got execute permission on DBMS_SCHEDULER.
  All the help in this regard will be appreciated.</p>
  
  <p>Lots of thanks,for taking out the time!</p>