F45: Call to dbms_job.run hanging

I have a form that calls the dbms_job.run procedure as shown below.

Everything works well if there is no problem running the job.

The form hangs if there is a problem with the job (e.g. I have a job that is supposed to use a database link to a machine that is not on my home network).

I've traced it to the FORMS_DDL that does the call to dbms_job.run.

PROCEDURE run_job
IS

    v_sql_string VARCHAR2(200);
BEGIN
    set_application_property(cursor_style, 'BUSY');     v_sql_string := 'BEGIN '

||'DBMS_JOB.RUN( job => '||:job.job
||');'
||'END;'

                ;

    FORMS_DDL(v_sql_string);
    set_application_property(cursor_style, 'DEFAULT');     IF FORM_FAILURE THEN
        show_error_message('run');
    ELSE
        show_success_message('run');
    END IF;
END run_job;

I expected to get a FORM_FAILURE which I could track, but it doesn't get that far with bad jobs!

Any thoughts?

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================