IBM Advanced Studies

 View Only

How to call Stored Procedure from My SQL in ESQL

  • 1.  How to call Stored Procedure from My SQL in ESQL

    Posted Mon January 22, 2024 10:20 AM

    How to call Stored Procedure from My SQL in ESQL(IBM ACE V12). I am Calling Stored Procedure from My SQL with regular Syntax given by IBM with Call Statement but i getting error as '[MySQL][ODBC 8.2(a) Driver][mysqld-8.0.36]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ CALL InsertEmployee (  ? , ? , ? )  }' at line 1'.

    i tried many ways to solve this but I am not able to resolve this.

    Please Guide.



    ------------------------------
    Anand Macherla
    ------------------------------