SqlExec - Ora_hash in Goldengate
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.