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?
Oracle reserve word
Moderators: chulett, rschirm, roy
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...
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 50
- Joined: Wed Jul 14, 2004 7:56 am