What is the syntax to call a stored procedure that returns a result set?
using procob for oracle 11g
tried this:
EXEC SQL
DECLARE C1_CSR CURSOR FOR
CALL Package.procedure(field1, field2)
END-EXEC.
----------------
EXEC SQL
OPEN C1_CSR
END-EXEC.
---------
EXEC SQL
FETCH C1_CSR INTO WS-RETURN-VALUE
END-EXEC.
+2What is the syntax to call a stored procedure that returns a result set?
using procob for oracle 11g
tried this:
EXEC SQL
DECLARE C1_CSR CURSOR FOR
CALL Package.procedure(field1, field2)
END-EXEC.
----------------
EXEC SQL
OPEN C1_CSR
END-EXEC.
---------
EXEC SQL
FETCH C1_CSR INTO WS-RETURN-VALUE
END-EXEC.
Pro*COBOL is not a Micro Focus product so we do not document it. Pro*COBOL is an Oracle product and you can find the documentation for it here:
If you search for "stored procedure" within the text you will find an explanation and an example.
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
