Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Tables/Procedures via SPT on Oracle
Message
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00538544
Message ID:
00538699
Views:
12
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform