December 29, 2008

TIP: ODBC Stored Procedure Execution

To call a stored procedure on an ODBC connection, use the following syntax:

{call procedure_name (param1 = param1Value, param2 = param2Value, ...)}

Or, if you are calling through some kind of command object, replace the parameter name/values with question mark placeholders, as follows:

{? = call procedure_name (?, ?)}
More information can be found here

No comments:

Post a Comment