PL/SQL (MOSC)

MOSC Banner

insert into an xmltype table using a trigger

edited Dec 8, 2018 5:50AM in PL/SQL (MOSC) 10 commentsAnswered

Hi guys.

I have not worked with xmltype tables before and am trying to integrate two different systems, one system is using xmltype tables and the other is using the normal  tables. Is it possible to create trigger on table X that inserts values to table Z once a new row is inserted into table X? Any assitance will be appreciated, See below the example of the to tables.

========Normal table====

create table x (tans_id number(15),trans_date date,currency varchar2(3), amount number(15),account_no number(7) );

insert into x (trans_id,trans_date,currency,amount,account_no)

values(1,SYSDATE,'USD',3000,4780903)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center