Environment: pb8.0.4 (10923) + Oracle 10.2.0.1
PB data window condition for colname=: value or colname='aa', : the value for the parameter, the table has colname='aa' and colname='bb' records,
Even when the Oracle 10 to incoming data window parameter values' bb ', only to come out colname='aa' records, but even when the Oracle 9 all records can be found out,
If the condition is changed to colname=: value or colname2='aa', even when the Oracle 10 incoming parameters values' bb 'colname=' bb 'can be recorded,

CodePudding user response:

Tracking the executed SQL background, should be the problem of the code,

CodePudding user response:

You put the grammar of the dw perform again, and see what the result is,

CodePudding user response:

Dw the SQL statements in pl/SQL execution there is no problem, is to perform in PB have a problem

CodePudding user response:

Look at the trouble: http://topic.csdn.net/u/20080325/17/16a4b5ba-0a69-4ba3-9926-a183e7fa4b94.html

CodePudding user response:

Impossible, must be your dw syntax errors,
Check for specific dw grammar,

CodePudding user response:

Haven't met this situation.

CodePudding user response:

This simple ah, online search will get the answer.