GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

SqlExec - Ora_hash in Goldengate

edited Dec 10, 2018 4:03AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi Experts,

I would like to use ORA_HASH mechanism in extract parameter file, which will produce the hash value for couple of columns, something like :

SELECT ORA_HASH(ROW_ID||' '||PROCESS_TIMESTAMP||' '||SOFT_DELETE) FROM <table_name> WHERE ROW_ID='4-3RRV9';

if I use this statement in GG extract file, I need to use one variable which can hold that hash value. So whatever hash_value is travelling from source to target I will map that value to a target column for future reference.

How can I achieve this. Please help here.

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