Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: Running Oracle Forms without user intervention


    I want to write an Oracle Form 6i program which automatically calls a procedure to run an Oracle report and then updates some database tables without any user intervention. This form will be run as a scheduled job on the UNIX server.

    The question is where should I fire the procedure? I have tried using the Pre-Form trigger but hits the "can't use a restricted built-in" error at the point of "COMMIT" command.

    Thanks in advance for any advice.

    Lay Hoon

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Running Oracle Forms without user intervention

    Usually in Forms, where a restricted built-in is to be called, the code has to be moved to a KEY trigger, e.g. KEY-COMMIT in this case.

    But really, I can't understand why you would use Forms at all to create a scheduled batch process with no user intervention. Why not just a shell script that runs the report and a SQL Plus script, or perhaps an After Report trigger in the report itself?

Posting Permissions

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