Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro*C++ Resultset Data types question
icon7.gif  Pro*C++ Resultset Data types question [message #591287] Fri, 26 July 2013 03:07
Messages: 1
Registered: July 2013
Location: england
Junior Member

I want to migrate an application in pro*c as all the mass code of pro*c will be simplify as much as possible. To do so, i neet to access de data base data throw a resultset, so i don,t neet to know which data(And type, "int, string, etc") is extracted from the data base until i execute the query.

OCI library provides a resultset and by using the metadata object it,s possbile to know which kind of data type is the column you have acceesed in the select.

For example ( I have invented the example )

resultset rs = "Select name, age from clients";

execute rs;

Metadata m = rs->getMetaObjet();

int columnName = 0;
int columnAge = 1;

//It should return a number associated to string data type
short typeName = m->getColumnDataTupe( columnName );

//It should return a number associated to int data type
short typeAge = m->getColumnDataTupe( columnAge );

So typeName should give me the number associated to the string data type.
So typeAge should give me the number associated to the int data type.

Is there a way to do so in Pro*c++.

Thank you very much.
Previous Topic: Ora-01002 by select for update in SQL statement
Next Topic: help me to compile first proc
Goto Forum:

Current Time: Thu Dec 02 15:26:33 CST 2021