#35 oracle timestamp - sets wrong length for data

[Anthony Carter]

When doing a select * from table which contains a col defined as timpestamp(3) or timestamp(6) using oracle 11.2 and oorexx 4.10 - rexx/sql = version 26b2 - returns ORA-01406: fetched column value was truncated

[Mark Hessling]

Please try 2.6 Beta 3 in rxsql26B3_src.zip

[Anthony Carter]

Tried to use rxsql26b3 - when trying to compile

c:\rxsql26B3\ora\ora.c(2156) : warning C4244: 'function' : conversion from 'sb2' to 'ub1', possible loss of data
c:\rxsql26B3\ora\ora.c(2169) : error C2275: 'sb4' : illegal use of this type as an expression
C:\app32\acarter\product\11.2.0\client_1\oci\include\oratypes.h(76) : see declaration of 'sb4'
c:\rxsql26B3\ora\ora.c(2169) : error C2146: syntax error : missing ';' before identifier 'retlen'
c:\rxsql26B3\ora\ora.c(2169) : error C2065: 'retlen' : undeclared identifier
c:\rxsql26B3\ora\ora.c(2171) : error C2065: 'retlen' : undeclared identifier
c:\rxsql26B3\ora\ora.c(2173) : error C2065: 'retlen' : undeclared identifier
c:\rxsql26B3\ora\ora.c(2179) : error C2065: 'retlen' : undeclared identifier
c:\rxsql26B3\ora\ora.c(2189) : error C2065: 'retlen' : undeclared identifier

Trying to use against oracle "product\11.2.0\client_1\oci"

[Mark Hessling]

Sorry about that. My compiler is more forgiving than yours :-(

Move line 2169 in ora/ora.c which contains:
sb4 retlen;

to after line 2113

[Anthony Carter]

Moving the source line worked. tested on timestam(6) and timestam(3)

[Mark Hessling]

Set to pending awaiting release of v2.6