Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xla

979209Aug 12 2015 — edited Aug 13 2015

Hi,

I have a problem with XLA.

I need change ID in a transaction but this new value only I find it in ORIGIN Database.

example:

insert into table1 (CID, PARENTCID, Key1, ...) values (?,?,? ...)

I need recover Key2 from its Key1 and change it in the sentence.

I know how to do this change but my problem is that I don't know how can I find this new ID ( Key2) if it's not included in transaction and I can't query in origin database.

I believe that this problem has appeared before but i can't find anything about it. Perhaps in elements of "JMS classes for event handling" it could be possible found something that provide us this data.

Is it possible ? And if it was, how do it ???

Thanks in advance,

Babs.

Mensaje editado por: 979209

This post has been answered by ChrisJenkins-Oracle on Aug 13 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2015
Added on Aug 12 2015
6 comments
1,932 views