>Using the MS ODBC driver, I can not get multiple anything to be created with 1 SQLExec() function call. It all gets lumped into 1 object. I even tried it by submitting a SQL script file [using FileToStr] that I know works in SQL*Plus. That also fails. I have not tested with the Oracle drivers.
>
Hi Mark,
Well I was using the Oracle drivers with the same results so you don't have to go to the trouble. ;-)
Yes I know the feeling. The same utility that pumps the SQL block into Oracle also has the ability to create a script using StrToFile(). If that file is loaded in to SQL+Plus Worksheet or SQL Navigator's script editor, it runs without a problem.
Thanks for trying.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao