Precompilers and OCI (MOSC)

MOSC Banner

OCI SQLT_NUM and SQLT_DAT datatypes 11g

edited Apr 22, 2009 10:59PM in Precompilers and OCI (MOSC) 5 commentsAnswered
 Hy,  i have a program which take a dynamic sql statement, execute it and show the values.
 I used for the NUMBER datatype defined in the table's columns definitions the OCI mapping SQLT_NUM to store the number
 in a C string str_out_number, in the OCIDefineByPos.
 I used for the DATE datatype defined in the table's columns definitions the OCI mapping SQLT_DAT to store the date
 in a C string str_out_date, in the OCIDefineByPos.

My questions are :
1) how to convert the string str_out_number to a C double (or an int) and to print it ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center