Help sending sql into ORACLE

I am new to VBA and I am working in Excel 2002 (Windows XP). I am
connecting to an ORACLE database. I want to send several sql
"commands" into ORACLE that will not be returning any data. For
example, I want to send a "drop table" command, a "create table"
command and an "analyze table" command. (These commands set up a
filter file in the ORACLE database that will used in later queries.)
So far, I have been able to do this by creating the appropriate sql and
attaching it to a "record set". The sql runs in ORACLE when I open the
record set. However, the coding for this process seems pretty ackward
compared to other programing languages I have worked with. (For
example, in SAS there is a statement ("execute()") that allows you to
send sql statements into ORACLE without creating or expecting a
record/data set on the client side.)

My question is... After making the connection to ORACLE in VBA, is
there a technique/process for sending commands like this through
without creating a record set? (I am hoping there is something that
will simplify my code.) Any examples of code would be very helpful.

Thanks in advance.

Max

(PS. I am also new to Google groups. If there is a more appropriate
group for me to submit this question to, please let me know. Thanks.)

.

Relevant Pages

  • Re: I cant schedule more than one jobs with Oracle Scheduler
    ... scheduled jobs instead of raw sql commands if the commands tend to be ... Oracle doesn't force you to do it in some particular ... The problem is that SQL VARCHAR2 type ... wrapping it into a stored procedure will remove ...
    (comp.databases.oracle.server)
  • Re: Using Excel to call Oracle Stored procedure.
    ... change the provider "MSDASQL" to whatever is appropriate for Oracle ... Dim rst As ADODB.Recordset ... Dim SQL As String ... return a record set. ...
    (microsoft.public.excel.programming)
  • Re: ADO
    ... objADODBConnection.Execute strSQL, RecAffected ... Not sure about Oracle, but for ... MS SQL Server you may examine Errors collection of ADODB.Connection. ... > I have tried to get the message back in a record set by doing this ...
    (microsoft.public.scripting.vbscript)
  • Re: MS SQL server Meata data question
    ... >is better and the tools built in ... ... I think Oracle supports something they ... USER_TAB_COLUMNS that you query with ordinary SQL. ... 'SHOW' commands are for MySQL - such as 'SHOW TABLES'. ...
    (comp.lang.php)
  • Re: About table copying
    ... Can anybody tell me how can i copy a sql table (including its ... export and import commands. ... If you actually mean to another table within a schema or another table ... Also note there are four Oracle specific groups. ...
    (comp.databases)