Unix Technical Forum

Please help , about OCI Number format

This is a discussion on Please help , about OCI Number format within the Oracle Database forums, part of the Database Server Software category; --> HI, everyone! In OCI program, I want to get the number field value of a table just the same ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-24-2008, 07:14 AM
Sean
 
Posts: n/a
Default Please help , about OCI Number format

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???


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:19 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com