ORA-01008: not all variables bound

[Guest_imported]

The SQL is as follows:
and the problem is in the NVL line


SELECT
bcpy.ext_acct_id,
bcpy.bank_acct_nme,
bcpy.sec_acct_id,
bcpy.eff_tms,
bcpy.trn_cde,
bcpy.iss_id,
bcpy.payment_amt,
bcpy.payment_curr,
bcpy.payment_sts
FROM
hb_t_bcpy bcpy
WHERE
bcpy.eff_tms = &S_EFF_TMS
AND bcpy.trn_cde = NVL(&S_TRN_CDE, bcpy.trn_cde)
ORDER BY
bcpy.ext_acct_id

 

[tlbroadbent]

This looks like an Oracle specific question. You'll probably get an answer in an Oracle forum. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin