When executing from SQLPlus... are you actually using a bind variable or are you using a literal? e.g. the actual value?