[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Starting an Oracle Job from a Trigger

Asked by OliShim in Oracle Database, PL / SQL, Oracle 9.x

Tags: orace, job, trigger, stored procedure.

Hello,

I had read some where on the net that it is possible to start an oracle job via a trigger and have the job call a stored procedure. Here's what I want.

Trigger (ON INSERT) > Job > Stored Procedure.

I had the trigger calling the stored procedure directly but that was causing problems with the data not yet being committed on other tables. Some one suggested I call a Job instead and a delay of a few seconds (WAITFOR). This should address the timing issue.

I have my stored procedure already written. Can any one please guide me towards writing the oracle job and how to have the trigger call the job? I'm using oracle 9i. Any help will be greatly appreciated. Thanks in advance.
[+][-]11/06/09 10:06 AM, ID: 25761427Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 11:32 AM, ID: 25762308Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 01:14 PM, ID: 25763115Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625