OO4O & VB6

From: Gennady <gennadyb_at_halcosoftware.com>
Date: Mon, 7 Jun 1999 15:04:49 -0700
Message-ID: <375c402b$0$17797_at_fountain.mindlink.net>

Hello,
I'd like to execute the block of SQL script :

   spool D:\project\DBdata\x.sql
   select 'drop ' || object_type || ' ' || owner || '.' || object_name || ';'

   from all_objects
   where owner='GB'
   and object_type in ('TABLE','VIEW','SEQUENCE');    spool off
   _at_D:\project\DBdata\x.sql

from my VB application using Oracle Objects for OLE connection like objDataBase.ExecuteSQL(strSQL).
How can I put the block into strSQL?

Regards,
Gennady Received on Tue Jun 08 1999 - 00:04:49 CEST