Kbase P31284: Getting oracle error 1008 with Oracle 9i with HPUX11
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/4/2010 |
|
Status: Verified
SYMPTOM(s):
oracle error 1008
Not all variables bound
Added qt_no_bind_where to the client startup and still get the error
Queried a field using substring of one field in the where clause as
FOR EACH X WHERE ...:
FIND FIRST Y WHERE a = b
and substring(c, 4, 18) = d no-error.
IF AVAILABLE Y...
Use of TRIM after the substring solved the problem as
TRIM(substring(c, 4, 18)) = d no-error.
FACT(s) (Environment):
Progress 9.1D
HP-UX 11.0 64-bit
Oracle DataServer
CAUSE:
The exact cause is unknown. However, not using trim function after substring may have caused an extra space in the value which is causing the error. Use of TRIM is always suggested when using substring function.
FIX:
Use TRIM function.