Hello,



I'm doing a web application that connects to an Oracle Database.



My problem is: in ASP how do I call an Oracle job that contains a stored

procedure?



I can't create and run the job in my page, but the same string works

perfectly in SQL ... that's what i'm trying is:



SQL = "declare nojob number; begin

DBMS_JOB.SUBMIT(:nojob,'hist;',SYSDATE, 'SYSDATE+1');

DBMS_JOB.BROKEN(:nojob, TRUE, SYSDATE);end; "



 conn.execute(SQL)



Gives this error when it tries to execute the string:



Microsoft OLE DB Provider for ODBC Drivers error '80040e10'



[Microsoft][ODBC driver for Oracle][Oracle]ORA-01008: not all variables

bound



/ror/historico.asp, line 93





What am i doing wrong ?



Thanks,

Ana