Problem with DBMS_JOB within a stored procedure

Hello-

I've done a fair amount of searching on this topic and haven't found exactly what i'm looking for. At the most simple level, I'm calling DBMS_JOB.SUBMIT within a stored procedure.

code looks like this:

IF saved_search_in <> 0
THEN
URL_UID := local_search_uid;
DBMS_JOB.SUBMIT (jobno,'SCHEDULE_SEARCH_URL(URL_UID);',sysdate,'sysdate+1'); commit;
END IF; where URL_UID is constructed in the lines of code above the DBMS_JOB call. getting ORA-06512 errors...i tried messing with the scope of the variable too, which i'm thinking is the right track, but i'm still getting nowhere.

so, to sum it up...can i use a variable in DBMS_JOB.SUBMIT from within the same procedure that i'm using to call DBMS_JOB?

thanks in advance Received on Wed Jul 02 2003 - 17:26:45 CDT