Rules to pass an event-based job - Oracle DBA

Q.  The Scheduler can pass an event-based job for the message content of the event that started the job. To pass an event-based job which of the following rules will be applied?
- Published on 13 Aug 15

a. The job must use a named program of type STORED_PROCEDURE
b. One of the named program's arguments must be a metadata argument with metadata_attribute set to EVENT_MESSAGE
c. The stored procedure that implements the program must have an argument at the position corresponding to the named program's metadata argument. The argument type must be the data type of the queue where your application queues the job-start event
d. Both A & B
e. All mentioned above

ANSWER: All mentioned above


  • Nirja Shah   -Posted on 30 Sep 15
    - If you use the RUN_JOB procedure to manually run a job that has an EVENT_MESSAGE metadata argument, the value passed to that argument is NULL

    Stored procedure
    - It is a subroutine available to applications that access a relational database system.

    - A stored procedure (sometimes called a proc, storp, sproc, StoPro, StoredProc, StoreProc, sp or SP) is actually stored in the database data dictionary.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)