Please help , about OCI Number format

From: Sean <hex_at_ict.ac.cn>
Date: Fri, 3 Sep 2004 20:24:26 +0800
Message-ID: <ch9nqo$31ir$1@mail.cn99.com>

HI, everyone!
In OCI program,
I want to get the number field value of a table just the same as select it in sqlplus.

e.g.
SELECT * FROM ttt;
SQL> select * from ttt

ID F
---------- ----------

         1     1.1234
         2     1.1234
         3     1.1234
         4    1.34421
      1748     2.3424
     34444      234.3
1.1111E+38          4
1.1000E+34          5
3.4123E+49       5747

But, in my OCI program, when defined with SQLT_STR, never get the above value, just like:

1               1.1234
2               1.1234
3               1.1234
4               1.34421
1748            2.3424
34444           234.3
111111111111111111111111111111111111111         4
11000000000000000000000000000000000             5
3412341413214240000000000000000000000000000             5747

How to implement like the sqlplus??? Received on Fri Sep 03 2004 - 07:24:26 CDT