Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle and executing procedurs
Message
From
12/03/1998 11:51:27
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00084159
Message ID:
00084187
Views:
23
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!!
Previous
Reply
Map
View

Click here to load this message in the networking platform