Forum Stats

  • 3,826,879 Users
  • 2,260,720 Discussions
  • 7,897,109 Comments

Discussions

Execute procedure independently

594664
594664 Member Posts: 33
edited Aug 11, 2009 11:41AM in Forms
Hi guys,

i have a problem i have a procedure that will execute for 1 hr when i click a button in the front end form(i am using forms 6I and database 10G) so my requirement is when the button in the front end is pressed the procedure shud be called (Thats Easy) and the front end shud continue after triggering the procedure(hard part) leaving the process to continue in the backend and the application to continue from frontend.

this cannot be scheduled it shud be called only when button pressed.

any suggestions ???


Ravi Kumar.
Tagged:

Answers

  • 548625
    548625 Member Posts: 717
    You could put your procedure on the database, and create a automatic job via [dbms_job | http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_job.htm#ARPLS019] (Database < 10g) or [dbms_scheduler | http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#CIHHBGGI] (10g and higher)

    regards
  • 49905
    49905 Member Posts: 604 Bronze Badge
    I guess, simplest would be dbms_job without specifying next_date and interval.
    This will default execution to start immediate and no repeat. don't forget to commit after submission.
     
    DECLARE 
       v_job   BINARY_INTEGER; 
    BEGIN 
       DBMS_JOB.SUBMIT (v_job, 'your_procedure;'); 
       FORMS_DDL ('commit'); 
       MESSAGE ('procedure submitted. job id:' || v_job); 
    END; 
This discussion has been closed.