Dear Chris,
I am using MF Server Expres 5.x and my program is calling an Stored Procedure.
When y put
EXEC SQL
CALL TESTGENERICO (:L991C-MENSAJE)
END-EXEC.
The program Run...
When I Put
MOVE "TESTGENERICO" TO PROCNAME.
EXEC SQL
CALL "PROCNAME" (:L991C-MENSAJE)
END-EXEC.
The program DONTS RUN......
Any Tips abiut This ???
PJM
+1Dear Chris,
I am using MF Server Expres 5.x and my program is calling an Stored Procedure.
When y put
EXEC SQL
CALL TESTGENERICO (:L991C-MENSAJE)
END-EXEC.
The program Run...
When I Put
MOVE "TESTGENERICO" TO PROCNAME.
EXEC SQL
CALL "PROCNAME" (:L991C-MENSAJE)
END-EXEC.
The program DONTS RUN......
Any Tips abiut This ???
PJM
Hello Pedro,
Which database implementation are you working with?
In order to vary the procedure name, I believe you may need to use Dynamic SQL. You can find information about using Dynamic SQL, as well as an example of using it for CALL statements in the Micro Focus Server Express Documentation in the section labeled Database Access Guide. Here is a direct link to that section:
supportline.microfocus.com/.../dbdyna.htm
Please scroll down to the section titled "Call Statements"
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
