Hello, I have created a package that manages users (add,modify ...)on a Oracle8 DB. works fine,this is how I call the procedure to add a user:<br><br>EXECUTE UserMgrProc.AddUserProc('name_xyz','passwd_xyz','dataBase_name');<br><br>I then created a package that uses dbms_job to create my users at night and I have a few problems. <br>If i submit my job directly it works, this is the code that works with hard coded values for name, passwd and DB_name:<br><br>EXEC DBMS_JOB.SUBMIT (User_JOB_CONTROL.JOBNO,'UserMgrProc.AddUserProc(''TOTO'',''TATA'',''SGBR'');', (SYSDATE+2/1440), NULL);<br><br>using this I created a procedure that dinamicly puts everything together, opens a cursor (Handle := DBMS_SQL.OPEN_CURSOR
and then parses my commande (DBMS_SQL.PARSE). SQL tells my everything is fine, I execute my new procedure and it tells me it was succesful, BUT IT DOESN'T WORK! I check with :<br><br>select JOB,LOG_USER,next_date,next_sec from USER_MGR.user_jobs; or .dba_jobs;<br><br>and there is nothing. If I don't parse I see my jobs. <br>Is my problem well explained? does anyone know what I am talking about? do you need more code? thank you, Szabo.
and then parses my commande (DBMS_SQL.PARSE). SQL tells my everything is fine, I execute my new procedure and it tells me it was succesful, BUT IT DOESN'T WORK! I check with :<br><br>select JOB,LOG_USER,next_date,next_sec from USER_MGR.user_jobs; or .dba_jobs;<br><br>and there is nothing. If I don't parse I see my jobs. <br>Is my problem well explained? does anyone know what I am talking about? do you need more code? thank you, Szabo.