Our schema, out of my control, uses raw datatype to store guids and the input tool recognizes it as a blob, which it is not. I have used rawtohex() to have the input tool recognize the correct value and be able to work with it. I am trying to transfer data from one oracle db to another with the same schema. The output tool has a similar issue which is preventing me from using the update: insert if new functionality as it does not recognize the primary key. I have tried an step to bring the table in, create a new one with a string column, the post add a primary key, but run into the same issue on output again.
