24,855
社区成员
发帖
与我相关
我的任务
分享
#include <iostream>
#include <vector>
#include<occi.h>
using namespace std;
using namespace oracle::occi;
int main()
{
try
{
Environment *env = Environment::createEnvironment(Environment::OBJECT);
Connection *conn=env->createConnection("WJF","WJF");
Statement *sm=conn->createStatement();
try
{
sm->setSQL("begin pr_InsertTest(:1,:2,:3); end;");
sm->setString(1,"wjf");
sm->setNumber(2,20);
sm->setDate(3,Date::getSystemDate(env));
sm->execute();
}
catch(SQLException &ex)
{
conn->terminateStatement(sm);
env->terminateConnection(conn);
Environment::terminateEnvironment(env);
cout << "Error running demo : " << ex.getMessage() << endl;
throw;
}
conn->terminateStatement(sm);
env->terminateConnection(conn);
Environment::terminateEnvironment(env);
}
catch (SQLException &ex)
{
cout << "Error running demo : " << ex.getMessage() << endl;
}
return 0;
}