Oracle Update SQL Explain Plan

chulett · Post by **chulett** » Fri Dec 04, 2009 8:22 am

I have absolutely no idea - let us know what you find out when you ask IBM.

mddw08 · Post by **mddw08** » Thu Dec 10, 2009 8:29 pm

We are having the same problem here when an indexed column is a character data type (char or varchar2). DataStage does something with the bind variables (ORCHESTRATE.INV_BK in your case) and Oracle gets confused. As a workaround, we wrap the bind variables used in the where clause of an update statement in a character conversion function. Try to raplace ORCHESTRATE.INV_BK with TO_CHAR(ORCHESTRATE.INV_BK) if it's a character fileld.