Updatable subscription in Transactional Replication

I am trying to setup a Transactional Replication for my data. My publisher and distributor is MS-SQL 2000 server; while subscriber is on a Oracle server. All are locally installed. I have also setup the linked server connection and created the publication. Data is able to be replicated correctly onto my Oracle database.

However, this time ard, I want my changes in the oracle database to be reflected back into the SQL database. So I had my publication re-setup with Updatable Subscription. I tried to test it out by making some changes in my SQL database, and my Distribution Agent failed, with error "Invalid HEX number".

I believe this is due to the uniqueidentifier datatype created during my publication creation, where this GUIDCOL is being added by the wizard. I have tried to add a new column in my oracle schema with datatype RAW(16), but it does not help.

1. Can someone tell me how to store the uniqueidentifier in binary string format?ie. 'DD52AD13227C463D822D1D2CA0807CC' instead of 'DD52AD13-227C-463D-822D-1D2CA0F807CC'

2. Or is there another datatype that can be used in Oracle to store the uniqueidentifier?
Thank you!!
Cheers,
Kevin

[1321 byte] By [KevinKan] at [2008-1-28]