| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Loader/Trigger question
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06C92.8CF90950
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
you may not automatically achieve this since triggers get disabled.
One way is you can schedule your procedure as a job which will work on the
recently inserted records based on some key value or timestamp. One more
option would be to run the procedure manually after the upload, instead of
through dbms_job.
Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com
amar_padhi_at_musclemail.com
http://AmZone.netfirms.com
-----Original Message-----
From: Bala, Prakash [mailto:prakash.bala_at_cingular.com]
Sent: Thursday, December 21, 2000 9:22 PM
To: Multiple recipients of list ORACLE-L
Subject: Loader/Trigger question
Hi,
I have an after insert trigger (statement level) that kicks off a procedure. This works fine when I use the conventional load. But my application demands that I need to use the direct load option.
Since the 'direct load' option disables the trigger, do you have any ideas how to accomplish this task?
TIA
Prakash
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: prakash.bala_at_cingular.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C06C92.8CF90950 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Fri Dec 22 2000 - 21:43:45 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: Loader/Trigger question</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi,</FONT>
<BR><FONT SIZE=3D2>you may not automatically achieve this since =
triggers get disabled.</FONT>
<BR><FONT SIZE=3D2>One way is you can schedule your procedure as a job =
which will work on the recently inserted records based on some key = value or timestamp. One more option would be to run the procedure = manually after the upload, instead of through dbms_job.</FONT></P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Amar</FONT>
<BR><FONT SIZE=3D2>00-971-50-7883254</FONT>
<BR><FONT SIZE=3D2>ts2017_at_emirates.com</FONT>
<BR><FONT SIZE=3D2>amar_padhi_at_hotmail.com</FONT>
<BR><FONT SIZE=3D2>amar_padhi_at_musclemail.com</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://AmZone.netfirms.com" =
TARGET=3D"_blank">http://AmZone.netfirms.com</A></FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Bala, Prakash [<A =
HREF=3D"mailto:prakash.bala_at_cingular.com">mailto:prakash.bala_at_cingular.c= om</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, December 21, 2000 9:22 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Loader/Trigger question</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi,</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2>I have an after insert trigger (statement level) =
that kicks off a procedure.</FONT>
<BR><FONT SIZE=3D2>This works fine when I use the conventional load. =
But my application demands</FONT>
<BR><FONT SIZE=3D2>that I need to use the direct load option.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2>Since the 'direct load' option disables the trigger, =
do you have any ideas</FONT>
<BR><FONT SIZE=3D2>how to accomplish this task?</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2>TIA</FONT>
<BR><FONT SIZE=3D2>Prakash</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Bala, Prakash</FONT>
<BR><FONT SIZE=3D2> INET: prakash.bala_at_cingular.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |