I get "PL/SQL ORA-01008 : Not all variables bound" error when I run or execute SQL statement with Bind Variable that uses numbers. This worked fine in 7.4.1.
Example Script:
SELECT COUNT(*) ITEM_ID
FROM (SELECT MAX(A.ITEM_ID)
FROM MF_ITEM A,
MF_ITEM_PRICE B,
MF_ITEM_DEVICE D,
MF_FILE_EXTENSION E,
MF_LIST_ITEM X
WHERE A.ITEM_ID = B.ITEM_ID (+)
AND A.STATUS = :1
AND A.FILE_EXTENSION_ID = E.EXTENSION_ID (+)
AND A.ITEM_ID = D.ITEM_ID
AND D.DEVICE_ID = :2
AND A.ITEM_ID = X.ITEM_ID
AND X.LIST_ID = :3
AND CASE WHEN NVL(X.DEVICE_ID, 0) = 0 THEN 1
WHEN NVL(X.DEVICE_ID, 0) > 0
AND X.DEVICE_ID = :4 THEN 1
WHEN NVL(X.DEVICE_ID, 0) > 0
AND X.DEVICE_ID <> :5 THEN 0
ELSE 0 END = 1
AND A.WAP_BROWSABLE = 1
GROUP BY A.DEVICE_DISPLAY_NAME, A.ARTIST, A.DEVELOPER_NAME,
A.COMPANY_ID, NVL(A.BUNDLE_TYPE_ID, 0), NVL(A.MATURITY_FLAG, 0),
NVL(A.ITEM_TYPE_ID, 0), NVL(A.ITEM_SUB_TYPE_ID, 0))
WORKAROUND:
Instead of using 'numbers' for your bind variables, use 'letters' instead (i.e. use :a instead of :1)
STATUS:
Waiting for fix in a future release of Quest SQL Optimizer for Oracle.
