Executing statement and commiting statement via qtp

[unbeliever]

Actually there can be a problem, sql statements which are executable in SQL Plus require different syntax in SQL Developer, otherwise - cannot be executed and result in exactly the same manner: Invalid SQL statement.

For example:
- in SQL Plus I execute statement like this: exec statement
- in SQL Developer I wrap statement:

Code:

begin;
exec statement
end;

As for my current code it's below:

Code:

Dim oConn
Dim strConn
Dim strQuery

Set oConn = CreateObject("ADODB.Connection")
Set oRecSet = CreateObject("ADODB.Recordset")
Set oCommand = CreateObject("ADODB.Command")
oConn.Open "Driver={Microsoft ODBC for Oracle};Server=myserver.com;Uid=user;Pwd=pwd;"
oCommand.ActiveConnection = oConn
oCommand.CommandText = "exec STATEMENT"
oCommand.Execute
oConn.Close