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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only