SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-24373 - Invalid length specified for statement

757723May 24 2010 — edited May 24 2010

Hi guys,

I have a sql statement like below,

SELECT TPLNBR_PL_REP.M_H_CUS_REP, TPLNBR_PL_REP.M_H_CUS_SBU, TPLNBR_PL_REP.M_H_REPAY, TPLNBR_PL_REP.M_H_CUS_NAME, TPLNBR_PL_REP.M_H_TRN_MTH2, TPLNBR_PL_REP.M_H_NB, TPLNBR_PL_REP.M_H_TRN_MTH, TPLNBR_PL_REP.M_TP_PFOLIO, TPLNBR_PL_REP.M_H_AMOUNT, TPLNBR_PL_REP.M_H_TINT_MYR, TPLNBR_PL_REP.M_TP_NBLTI, TPLNBR_PL_REP.M_H_INTDUE, TPLNBR_PL_REP.M_H_TTL_INT, TPLNBR_PL_REP.M_TP_RPO_AMT, TPLNBR_PL_REP.M_TP_RPOAMT2, TPLNBR_PL_REP.M_H_TENOR3, TPLNBR_PL_REP.M_H_SEC_DESC, TPLNBR_PL_REP.M_QTY_INDEX, TPLNBR_PL_REP.M_TP_ENTITY, TPLNBR_PL_REP.M_PLIRDACC11, TPLNBR_PL_REP.M_H_TENOR2, TPLNBR_PL_REP.M_H_REPDATE1, TPLNBR_PL_REP.M_REF_DATA, TPLNBR_PL_REP.M_TPID, TPLNBR_PL_REP.M_TP_BUY, TPLNBR_PL_REP.M_TP_BUY_E, TPLNBR_PL_REP.M_TP_CLIENT, TPLNBR_PL_REP.M_TP_CNTRP, TPLNBR_PL_REP.M_TP_DTEEXP, TPLNBR_PL_REP.M_TP_DTEPMT, TPLNBR_PL_REP.M_TP_DTESYS, TPLNBR_PL_REP.M_TP_DTETRN, TPLNBR_PL_REP.M_TP_INT, TPLNBR_PL_REP.M_TP_IPAY, TPLNBR_PL_REP.M_TP_IQTY, TPLNBR_PL_REP.M_TP_IQTYS, TPLNBR_PL_REP.M_TP_NOMCUR, TPLNBR_PL_REP.M_TP_NOMINAL, TPLNBR_PL_REP.M_TP_PRICE, TPLNBR_PL_REP.M_TP_PRICE2, TPLNBR_PL_REP.M_TP_RTACR02, TPLNBR_PL_REP.M_TP_RTAMC02, TPLNBR_PL_REP.M_TP_RTBUY, TPLNBR_PL_REP.M_TP_RTFLWAD, TPLNBR_PL_REP.M_TP_RTMRTE0, TPLNBR_PL_REP.M_TP_RTMRTE1, TPLNBR_PL_REP.M_TP_SECLBL, TPLNBR_PL_REP.M_TP_SECMKT, TPLNBR_PL_REP.M_TP_STATUS1, TPLNBR_PL_REP.M_TP_STATUS2, TPLNBR_PL_REP.M_TP_TRADER, TPLNBR_PL_REP.M_TP_VALSTAT, TPLNBR_PL_REP.M_TP_YIELD, TPLNBR_PL_REP.M_TRN_FMLY, TPLNBR_PL_REP.M_TRN_GRP, TPLNBR_PL_REP.TIMESTAMP, TPLNBR_PL_REP.M_IDENTITY, TPLNBR_PL_REP.M_H_CUSAC, TPLNBR_PL_REP.M_H_CUSBR, TPLNBR_PL_REP.M_H_CUSTOMER, TPLNBR_PL_REP.M_H_INT_MYR, TPLNBR_PL_REP.M_H_LDCODE, TPLNBR_PL_REP.M_H_LDTYPE, TPLNBR_PL_REP.M_H_NOM_MYR, TPLNBR_PL_REP.M_H_NOM_REPO, TPLNBR_PL_REP.M_H_REPDATE2, TPLNBR_PL_REP.M_H_REPO_SM, TPLNBR_PL_REP.M_H_SEC_CODE, TPLNBR_PL_REP.M_H_SPOT_RTE, TPLNBR_PL_REP.M_H_TENOR, TPLNBR_PL_REP.M_H_TOTALAMT, TPLNBR_PL_REP.M_INSTRUMENT, TPLNBR_PL_REP.M_MX_PFOLIO, TPLNBR_PL_REP.M_MX_REF_JOB, TPLNBR_PL_REP.M_NB, TPLNBR_PL_REP.M_PLIRDACS11, TPLNBR_PL_REP.M_PLIRDACS12, TPLNBR_PL_REP.M_PLIRDFCS11, TPLNBR_PL_REP.M_PLIRDFCS12, TPLNBR_PL_REP.M_PLIRDFCS21, TPLNBR_PL_REP.M_PLIRDFCS22, TPLNBR_PL_REP.M_PLIRDFPV11, TPLNBR_PL_REP.M_PLIRDFPV12, TPLNBR_PL_REP.M_PLIRDFPV22, TPLNBR_PL_REP.M_PLIRDNFC11, TPLNBR_PL_REP.M_PLIRDNFC12, TPLNBR_PL_REP.M_PLIRDNFC21, TPLNBR_PL_REP.M_PLIRDNFC22, TPLNBR_PL_REP.M_PLIRDNFP11, TPLNBR_PL_REP.M_PLIRDNFP12, TPLNBR_PL_REP.M_PLIRDNFP21, TPLNBR_PL_REP.M_PLIRDNFP22, TPLNBR_PL_REP.M_PL_CGR1, TPLNBR_PL_REP.M_PL_CGR2, TPLNBR_PL_REP.M_PL_CGU1, TPLNBR_PL_REP.M_PL_CGU2, TPLNBR_PL_REP.M_PL_CSNFCP1, TPLNBR_PL_REP.M_PL_CSNFCP2, TPLNBR_PL_REP.M_PL_CSNFR1, TPLNBR_PL_REP.M_PL_CSNFR2, TPLNBR_PL_REP.M_PL_CSNFRV1, TPLNBR_PL_REP.M_PL_CSNFRV2, TPLNBR_PL_REP.M_PL_EFFY1, TPLNBR_PL_REP.M_PL_EFFY2
FROM TPLNBR_PL_REP
WHERE TPLNBR_PL_REP.M_TP_INT <> 'Y' AND TPLNBR_PL_REP.M_TP_MOPLST <> 7 AND TPLNBR_PL_REP.M_TP_MOPLST <> 5 AND TPLNBR_PL_REP.M_TP_MOPLST <> 6 AND TPLNBR_PL_REP.M_REF_DATA = :MxDataSetKey AND TPLNBR_PL_REP.M_TP_DTETRN >= :sFirstTradeDate AND TPLNBR_PL_REP.M_TP_DTETRN <= :sSecondTradeDate AND TPLNBR_PL_REP.M_TP_TYPO LIKE '%STMMD%' AND TRIM(TPLNBR_PL_REP.M_H_CUS_REP) LIKE '%'||:REP||'%'

:MxDataSetKey, :sFirstTradeDate and :sSecondTradeDate and :REP are parameters that will be passed to the sql statement.

However when I run the sql statement above, I got the error message,'ORA-24373 - Invalid length specified for statement'. Any ideas guys? Thanks.