#35 oracle timestamp - sets wrong length for data

v1.0 (example)
pending
Mark Hessling
None
5
2013-06-12
2011-05-22
Anthony Carter
No

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

Discussion

  • Mark Hessling
    Mark Hessling
    2011-05-23

    Please try 2.6 Beta 3 in rxsql26B3_src.zip

     
  • Mark Hessling
    Mark Hessling
    2011-05-23

    • assigned_to: nobody --> rexx
    • status: open --> pending-fixed
     
  • Anthony Carter
    Anthony Carter
    2011-05-23

    • status: pending-fixed --> open-fixed
     
  • Anthony Carter
    Anthony Carter
    2011-05-23

    • status: open-fixed --> open-wont-fix
     
  • Anthony Carter
    Anthony Carter
    2011-05-23

    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
    Mark Hessling
    2011-05-23

    • status: open-wont-fix --> pending-fixed
     
  • Mark Hessling
    Mark Hessling
    2011-05-23

    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
    Anthony Carter
    2011-05-23

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

     
  • Anthony Carter
    Anthony Carter
    2011-05-23

    • status: pending-fixed --> open-fixed
     
  • Mark Hessling
    Mark Hessling
    2013-06-12

    • status: open-fixed --> pending
    • Group: --> v1.0 (example)
     
  • Mark Hessling
    Mark Hessling
    2013-06-12

    Set to pending awaiting release of v2.6