Home » Developer & Programmer » Precompilers, OCI & OCCI » OCCI Statement Class: get input parameters info
OCCI Statement Class: get input parameters info [message #213594] Thu, 11 January 2007 06:47
Defrag
Messages: 2
Registered: January 2007
Junior Member
Hi

How can I get number of input parameters and their types from Statement object for INSERT INTO... statement?

For, example:

std::string sqlQuery("INSERT INTO tab1(id, str) VALUES(:in_id, :in_str));
Statement *stmt = conn->createStatement (sqlQuery);
stmt->setInt(1, 1);
stmt->setString(2, "test_str");
....

In this example I know, that I must set 2 parameters. But what if I will enter sqlQuery dinamically? I will don't know number of input parameters and their types... How can I get this number and this types?
Previous Topic: getColumnListMetaData fails
Next Topic: Pro*C in UNIX Help NEEDED
Goto Forum:
  


Current Time: Thu Mar 28 12:26:50 CDT 2024