Export (0) Print
Expand All

srv_paramstatus

SQL Server 2000

Returns the status of a particular remote stored procedure call parameter.

Syntax

int srv_paramstatus (
SRV_PROC * srvproc,
int n );

Arguments

srvproc

Is a pointer to the SRV_PROC structure that is the handle for a particular client connection (in this case, the handle that received the remote stored procedure call). The structure contains information the ODS Library uses to manage communication and data between the Open Data Services server application and the client.

n

Indicates the number of the parameter. The first parameter is number 1.

Returns

An int that contains status flags for the parameter. Currently, there is only one flag: If bit 0 is set to 1, the parameter is a return parameter. If there is no nth parameter or if there is no remote stored procedure, returns -1.

Remarks

This routine returns the status flags for a remote stored procedure call parameter.

Parameters contain data passed between clients and the Open Data Services server application with remote stored procedures. The client can specify certain parameters as return parameters. These return parameters can contain values that the Open Data Services server application passes back to the client.

Currently, the only status flag is one that indicates whether the parameter is a return parameter.

Open Data Services can use srv_paramset to set the value of a return parameter.

When a remote stored procedure call is made with parameters, the parameters can be passed either by name or by position (unnamed). If the remote stored procedure call is made with some parameters passed by name and some passed by position, an error occurs. If an error occurs, the SRV_RPC handler is still called, but it appears as if there were no parameters, and srv_rpcparams returns 0.

See Also

srv_rpcparams

Show:
© 2014 Microsoft