Menu ▾ ▴

OCI_GetString Invalid value

OCILIB troubleshooting (ReadOnly - Use GitHub tracker instead)
Nobody/Anonymous
2008-03-17
2012-09-26

  • Nobody/Anonymous

    Nobody/Anonymous - 2008-03-17

    I have two environment and different result with same Query.

    • data type = number(10)
      value = 18600001

    • OS: linux 2.6.18
      Oracle : 10.2.0

    in functin OCI_ColumnMap(): scale=0, prec=10. so mapping to SQLT_INT
    OCI_GetString -> result='18600001'

    1. OS: AIX 5.2
      Oracle : 9.2.0.8.0

    in functino OCI_ColumnMap(): scale=0, prec=0. so mapping to SQLT_FLT
    OCI_GetString -> result='1.86e+07'

    My question is why OCI_GetString uses '%g' instead '%f' when column type is OCI_CDT_DOUBLE ?.
    I need '18600001' not '1.86e+07'

     

    • Vincent Rogier

      Vincent Rogier - 2008-03-17

      Hi Nobody,

      Version 2.2.0 (release by mid-week) will use '%g' instead '%f'.

      Thanks for reporting this little issue.

      Vincent.