Skip to main content

Calling stored procedure

  • April 30, 2015
  • 1 reply
  • 0 views
D

I have a SQL stored procedure that requires one input value and returns 2 output values. How do I code this in Visual Cobol?

    1 reply

    Blair McDonald

    I have a SQL stored procedure that requires one input value and returns 2 output values. How do I code this in Visual Cobol?

    Hello,

    In Visual COBOL, you would invoke a Stored Procedure using a CALL statement in an EXEC SQL block. Please see this link for documentation of this statement, including examples of specifying which parameters are input vs output.

    Also, here is a link to a video that discusses this topic in more detail:

    OpenESQL Calling Stored Procedures

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement