Forum Stats

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

Discussions

Categories

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:
· Share on TwitterShare on Facebook

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
    · Share on TwitterShare on Facebook
  • 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;
    · Share on TwitterShare on Facebook
This discussion has been closed.