SQLSetProcedureName - cSQLStatement
Setup a stored procedure name so it can be called.
Type: Procedure
Parameters
| Parameter | Type | Description |
|---|---|---|
| sProcName | String | Stored procedure name |
| sSchemaArg | String | Schema name |
Syntax
Procedure SQLSetProcedureName String sProcName String sSchemaArg
Call Example
Send SQLSetProcedureName sProcName sSchemaArg
Description
Set up the name of a stored procedure or stored function to call. Internally the Connectivity Kit will check the procedure definition on the backend database. It will allocate the room to store the arguments and return value, if any.
If the procedure is defined for a particular schema, you can optionally pass the schema name as the second parameter.
See the StoredProcedureMSSQL.vw and StoredProcedureODBC.vw views in the Specializd Components sample workspace for samples of calling a stored procedure.
Resets piLastArgument to 0.