execsp
Description
Makes a stored procedure call, essentially of the form EXECUTE followed by the spname, and then the params. If a recordset is returned, it is converted to XML and returned to the caller.
Input fields
XML tag | Description |
<spname> | Stored procedure name. |
<params> | Parameters to send. |
Return fields
OK with recordset or ERR
Example
Example invocation:
<func>execsp</func>
<spname>SIRIUSSP_GETQTYREMAINING_BY_DCI_BASE</spname>
<params>'10-19-2008 08:00:00', 'test', 'test', 'main', 0</params>
Example return string:
OK :...recordset
See also