Executing multiple SQL statements with RWDBDatabase::executeSql() on ORACLE

Article ID: 795
Last updated: 05 Feb, 2008
Article ID: 795
Last updated: 05 Feb, 2008
Revision: 1
Views: 5526
Posted: 26 Jun, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


How do I execute more than one SQL statement with the RWDBDatabase::executeSql() method on ORACLE?


Action


The following example shows how.
     RWDBDatabase database=RWDBManager::database("ORACLE","server", ...);
RWDBConnection conn = database.connection();
RWCString string("BEGIN
");

string.append("INSERT INTO TABLE1 VALUES (5);
");
string.append("INSERT INTO TABLE1 VALUES (6);
");
string.append("INSERT INTO TABLE1 VALUES (7);
");
string.append("END;");
RWDBResult res = database.executeSql(string, conn);
This article was:   Helpful | Not helpful
Report an issue
Article ID: 795
Last updated: 05 Feb, 2008
Revision: 1
Views: 5526
Posted: 26 Jun, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category