DSXchange

I have to update an Oracle reserve word (USER field) in the Oracle Stage. In Oracle, to update the USER field, it is just to append the double quotes.

Eg. UPDATE TABLE_A SET "USER" = ORCHESTRATE."USER".

But when I insert the statement that way in the Oracle stage, it gives me an error that the UPDATE statement is incorrect and needs to be verify. Does anyone has a solution to this?

Another way is to fully qualify the field name. Is that possible?

In the Server's version of the OCI stage you can check off a box that 'enables case sensitive' queries, which will automatically quote all of the objects referenced. That might be another option for you, but I don't have PX, so...

Thanks, chulett but sad to say, PX doesn't have the option in the Oracle stage. Anyway, changed the fieldname to a non-reserve word in Oracle.