|
For a pass-thru query with numbered parameters, the
character immediately after a numbered parameter occurs twice in the
generated SQL.
e.g., For an OQL of: CALL SQL SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM EMP WHERE ENAME=UPPER($1) AS scott.Emp the generated SQL looks like: SQL SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM EMP WHERE ENAME=UPPER(?)) Note the two closing parentheses in the generated
SQL.
I have filed a Bugzilla bug report for
this.
---
Sunil
|
