Getting error message ORA-01008: not all variables bound.

[Diane LaBrie]

I am new to writing SQL code not sure why I am getting this error ORA-01008: not all variables bound. If someone can look at my SQL code below and let me know what part of the code is incorrect I would really appreciate it.


SELECT O142261.HOLD, O142261.HOLD_AMOUNT, O142261.HOLD_DESC, O142261.HOLD_EXPLANATION, O142261.HOLD_FROM_DATE, O142261.HOLD_ORIGINATING_OFFICE_DESC, O142261.HOLD_TO_DATE, O219017.SPRIDEN_ID, O219017.SPRIDEN_LAST_NAME, O219017.SPRIDEN_FIRST_NAME, SYSDATE

FROM BANINST1.AS_HOLD O142261, SATURN.SPRIDEN O219017

WHERE ( ( O219017.SPRIDEN_PIDM = O142261.PERSON_UID ) ) AND ( O219017.SPRIDEN_CHANGE_IND IS NULL ) AND ( O219017.SPRIDEN_ENTITY_IND = 'P' ) AND ( O142261.HOLD = :"Type of Hold" ) AND ( O142261.HOLD_TO_DATE > :"Hold to Date" )

ORDER BY O219017.SPRIDEN_LAST_NAME ASC, O219017.SPRIDEN_FIRST_NAME ASC
;

[ck9663]

What does those ":" mean? If that means not equal, use != or <> instead.

Good Luck!!!

~~ CK

[gpl]

From googling, this line is your problem
( O142261.HOLD = :"Type of Hold" ) AND ( O142261.HOLD_TO_DATE > :"Hold to Date" )

prefixing a variable with : is a 'substitution variable', which needs defining.

If you post in the Oracle forum, you are likely to get more help

[Diane LaBrie]

Yes, it means not equal. I will try the code you recommended.

Thanks,

Diane

[Diane LaBrie]

Thanks for your help. If the code does not work I will post in the Oracle forum. Appreciate your help.