The Database API > Database API functions > MMDB.getSPParamsAsString() |
Availability
Dreamweaver UltraDev 1.0
Description
Gets a comma-delimited string containing the list of parameters that the stored procedure takes.
Arguments
connName, procName
connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
|
procName is the name of the stored procedure. |
Returns
A comma-delimited string containing the list of parameters that the stored procedure requires. The parameters' names, direction, and data type are included, separated by semicolons (;).
Example
The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast") could return a string of form name startDate;direction:in;datatype:date, salary;direction:in;datatype:integer
Here, the stored procedure, getNewEmployeesMakingAtLeast, has two parameters: startDate and Salary. For startDate, the direction is in and the data type is date. For salary, the direction is in and the data type is date.