My stored procedure without returning any recordset: (non query)
Running a stored procedure without returning any recordset: (non query)
Use the function CALL to specify the name of the stored procedure.
Example (Launches XYZ with the two parameters 2 & 5):
sql call XYZ ( 2 , 5 );
This works for both ODBC and OLE DB. However, when opening the connection using OLE DB, make sure to add (mode is write) before the finishing semi colon in the connection string.
and it still does not work:
SQL CALL TEST2;