Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Tables/Procedures via SPT on Oracle
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00538544
Message ID:
00538699
Vues:
11
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform