Re: trigger or job ?

hitchhikar wrote:

> Hi,
> Am having a confusion over an issue.
> Its like i have a XML of size 140k+ chars and i have to store it in
> OracleDB from C++ code and process it further using pl/sql.I am using
> ODBC (not OCCI) and Ora10g. I am doing this in 2 steps as follows:
> #1 - chunking the XML in 30k and storing in tblBoxXMLChunks(id
> number,xml_chunk clob).This is from C++ code
> #2 - In a proc (sprocCreateXML) reading all chunks related to an id and
> will store it in table tblBoxXMLfull(id number, xml_full clob) and then
> call the sproc to process the xml corresponding to each id.
> The rate at which the values are inserted in tblBoxXMLChunks is high.
> And i want to keep step 2 separate from C++ code(that is, after every
> all chunks of a particular XML is inserted i can call the
> sprocCreateXML, but this will slow down my process).
> So the confusion is should i perform step 2:
> 1. In a TRIGGER , which will be an INSERT trigger on tblBoxXMLChunks
> 2. In a job using DBMS_SCHEDULER
> 3. Use an ETL tool

> Any suggestions will be cool .
> TIA
> S

> ps: asktom and Morgan's library ROCKS. thankyou guys!

Why do you think you need to process it twice... Since you cannot do anything with the chunks table but put it back together in the full table - that is a wasted step. Just put the whole thing in the full table with the C++ app and be done with it. Received on Wed Mar 22 2006 - 14:26:30 CST