Hi *969700* ,

I am getting an error after trying to run an SQL statement with a bind variable. I have written numerous statement like these before, but this one is giving me this error:

report error:
ORA-01008: not all variables bound

Application Express 2.1.0.00.39 platform
>
Wow! That version is still in use!!
>
SELECT T1.AUDIT_DATE "AUDIT DATE",
T2.CLOCK_NUMBER "AUDITOR CLOCK #",
T2.LAST_NAME
|| ', '
|| T2.FIRST_NAME "AUDITOR'S NAME",
T4.SENSITIVE_ITEM "AUDITED ITEM",
T3.SI_DISPO
FROM TABLE TAB T1
LEFT JOIN TAB T3
ON T1.DISPOSITION = T3.DISPO_ID
LEFT JOIN TAB T4
ON T1.ITEM_ID = T4.LU_SI_ID
LEFT JOIN TAB T2
ON T1.ENTERED_BY = T2.EMP_ID
WHERE T1.ENTERED_BY = :P12_AUDITOR
>
This appears to be Report query.
If it is indeed a report query then it will expect the :P12_AUDITOR item to have some value in the session state , other than null.
>
The :P12_AUDITOR refers to an item that works off of a dynamic SQL select list which is:

SELECT UNIQUE T2.LAST_NAME || ', ' || T2.FIRST_NAME D, T2.EMP_ID R
FROM TAB1 T1
LEFT JOIN TAB2 T2
ON T1.ENTERED_BY = T2.EMP_ID
ORDER BY 1
>
Is the :P12_AUDITOR assigned a value before the Report Region is rendered?
The steps you follow when you get the error are not clear. Do you get the error the first time the page loads? Or, do you submit the page , with the :P12_AUDITOR item selection, when you get the error?

Run the page in Debug mode to see when and what values are assigned to P12_AUDITOR when you get the error.
>
Am I missing something here?>
Cheers,

I do not think it is a bug that you have hit, it is too basic to be a bug.
In all probability the page started working once the value of P12_AUDITOR was set in the session state.

To confirm whether the issue is really fixed by removing the concat you should re-login into the application and check. And preferably directly from the application URL, not when running the application within Application Builder.

Cheers,