How does one execute DML and DDL statements using OO4O?
Submitted by admin on Wed, 2005-11-09 23:38.
One can use any valid DDL and DML statement with the ExecuteSQL (or DBExecuteSQL) method. Look at this example:
rowcount = OraDatabase.ExecuteSQL("create table X (A date)")
rowcount = OraDatabase.ExecuteSQL("insert into X values (sysdate)")
OraSession.CommitTrans ' or OraSession.Rollback »
- Login to post comments

