Run query: ORA-01008: not all variables bound

[MohammedShabbir]

Hi @Hazem_Saleh

Could be your query uses some parameters more than once.

Oracle counts each appearance as a separate parameter — even fro same name.

Try if you can Change the WHERE condition so each parameter appears only once, like this:

WHERE CreditorName = NVL(:originalCreditorName, CreditorName)
AND CreditorAcc = NVL(:originalCreditorAccount, CreditorAcc)