Ns_DbSpSetParam

Overview

Syntax

    int Ns_DbSpSetParam(
    Ns_DbHandle *handle, 
    char *paramname, 
    char *paramtype, 
    char *inout, 
    char *value
    );

Description

In preparing to run stored procedure, this function sets a parameter to pass to that stored procedure. You must have executed Ns_DbSpStart first. The paramname is the name of the parameter, such as "@foo"; paramtype is the data type, such as "int" or "varchar". The inout argument is either "in" or "out", depending on what kind of parameter it is. The value argument is the value to pass to the stored proc, such as "123" (it's always a string). Returns NS_OK on success, NS_ERROR on failure.