Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    7

    Unanswered: Trigger question

    Hello

    I have made a TRIGGER in order to execute a PL/SQL process in muy database when I insert a record in one table.

    I want my process to execute in background mode, is it possible??, now my TRIGGER works, but is executing on-line and my app waits for this process.

    Is it possible to execute a process via trigger in background/batch mode???

    Any advice will be greatly aprecietted.

    Nauj

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    are you saying so your application does not wait for the results of the insert and trigger back from the database?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Call DBMS_JOB.SUBMIT from the trigger if you want it to do something asynchronously.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •