Hi experts and Gurus

I have a table(xml_table) with XML type field(col_xml) and this xml
stores data like
<member>
<Person_id>1</Person_id>
<Person_id>2</Person_id>
<Person_id>3</Person_id>
.
.
.
</member>

I have written a trigger for insert/update/delete.
This trigger will extract all person_id from XML and insert into a
relationa table(table_name)..

Part of TRIGGER looks like

IF INSERTING
Insert into temp_table(temp_xml)
Values (:new.col_xml);
Insert into table_name(person_id)
Select extract(temp_xml,'//person_id') from temp_table;
Commit;
ELSIF UPDATING
delete from where table_name where t_id=:new.id; // Let these
are dummy ids for reference...
Insert into temp_table(temp_xml)
Values (:new.col_xml);
Insert into table_name(person_id)
Select extract(temp_xml,'//person_id') from temp_table;


I am having a problem when XML is large and when I tried to UPDATE its
taking lot of time :(
Can any one tell me how to improve or is there any other way to handle
the same problem

Thanks,
Ravikumar



> Thanks,
> Ravikumar
>

----------------------------------------------------------------------
CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024.

Oracle LazyDBA home page