Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle and executing procedurs
Message
De
12/03/1998 11:51:27
 
 
À
12/03/1998 10:22:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00084159
Message ID:
00084187
Vues:
19
I found the answer to my own problem. While reviewing some questions on the ORACLE web site a similar question was asked.


And the answer is:

In ORACLE the 'execute' is not a command. When in native ORACLE when a user runs a stored procedure with the 'execute procedure_name' command the pre-compiler wraps the procedure_name with a 'BEGIN / END;'.

The result is instead of using the syntax of:
SQLEXEC(gnConnHandle,'execute procedure_name')

USE:
SQLEXEC(gnConnHandle,'BEGIN '+procedure_name+'END;')

It works!!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform