#include "occi.h"

using namespace std;
using namespace oracle::occi;


int main()
{

Environment* m_env;
Connection* m_conn;
Statement* m_stmt;

ResultSet * pSet = NULL;
vector<MetaData> listMetaData;

int nColumns;
const char* dbname = "XE";
const char* user = "hr";
const char* pass = "hr";
const char* query = "select * from jobs";

m_env = Environment::createEnvironment();
m_conn = m_env->createConnection(user, pass, dbname);
m_stmt = m_conn->createStatement(query);

Statement::Status status;
status = m_stmt->status();

if( status != Statement::PREPARED )
{
printf("The statement is not prepared.\n");
goto _EXIT;
}

try
{
status = m_stmt->execute();
pSet = m_stmt->getResultSet();
}
catch (SQLException &sqlExcp)
{
printf("SQL Exception\n");
goto _EXIT;
}

listMetaData = pSet->getColumnListMetaData();
nColumns = listMetaData.size();
printf("nColumns: %d\n", nColumns);

_EXIT:
m_conn->terminateStatement(m_stmt);
m_env->terminateConnection(m_conn);
Environment::terminateEnvironment(m_env);

return 0;

}