ED,
I'll agree with you, not knowing exactly what that app is doing could create
all kinds of havoc. Also, if the database as laid down by the vendor does not
have RI inside the DB doing so may cause the application to cease functioning.
That is because (like PeopleSoft for instance) they enforce the RI inside the
application and may populate the child records before the parents. This will
cause your RI triggers to fail. What may be a better idea is to replicate the
desired tables from the third party db into your Oracle financials DB and then
do whatever populating of the Oracle financials is required.
Dick Goulet
____________________Reply Separator____________________
Author: Ed Maurer <[EMAIL PROTECTED]>
Date: 8/6/2001 10:05 AM
In the course of customizing one of our 3rd party apps that uses
Entity Beans to do multiple inserts to some tables, It has been
decided we'd use triggers on the tables to do some RI logic and
insert essentially duplicate data into another database - Oracle
Financials interface, to be exact,
I've been opposed to this methodology, on the grounds that
nobody here can tell me exactly how this app is behaving
in the first place. I've heard that some beans do stupid (sic) things like
insert a row, then update each column in the course of a single
transactional insert, thus requiring both insert and update triggers;
performance could be nightmarish, assuming we don't hit 4091
errors even trying to write the code.
Unfortunately, without some hard facts, I'm going to have a
hard time convincing anyone this is bad practice. And
without tools to see exactly how the object(s) behaving, I won't
be able to prove it on our development platforms either.
Anyone have any experience here, or ideas for tools
(besides packet capture) that can assist ?
TIA
Ed Maurer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2479.6" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><SPAN class=718244416-06082001><FONT size=1>In the course of customizing
one of our 3rd party apps that uses</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Entity Beans to do multiple
inserts to some tables, It has been </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>decided we'd use triggers on
the tables to do some RI logic and</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>insert essentially duplicate
data into another database - Oracle</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Financials interface, to be
exact,</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>I've been opposed to this
methodology, on the grounds that</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>nobody here can tell me exactly
how this app is behaving </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>in the first place. I've heard
that some beans do stupid (sic) things like</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>insert a row, then update each
column in the course of a single</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>transactional insert, thus
requiring both insert and update triggers;</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>performance could be
nightmarish, assuming we don't hit 4091</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>errors even trying to write the
code.</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Unfortunately, without some
hard facts, I'm going to have a </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>hard time convincing anyone
this is bad practice. And</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>without tools to see exactly
how the object(s) behaving, I won't</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>be able to prove it on our
development platforms either.</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Anyone have any experience
here, or ideas for tools </FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>(besides </FONT></SPAN><SPAN
class=718244416-06082001> <FONT size=1>packet capture) that can assist
?</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1></FONT></SPAN> </DIV>
<DIV><SPAN class=718244416-06082001><FONT size=1>Ed
Maurer</FONT></SPAN></DIV></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
