storedProc method of the database object or of a Connection object. You do not call a Stproc constructor.
Stproc object, use the close method to close it and release the memory it uses. If you release a connection that has an open stored procedure, the runtime engine waits until the stored procedure is closed before actually releasing the connection.
If you do not explicitly close a stored procedure with the close method, the JavaScript runtime engine on the server automatically tries to close all open stored procedures when the associated database or Connection object goes out of scope. This can tie up system resources unnecessarily. It can also lead to unpredictable results.
You can use the prototype property of the Stproc class to add a property to all Stproc instances. If you do so, that addition applies to all Stproc objects running in all applications on your server, not just in the single application that made the change. This allows you to expand the capabilities of this object for your entire server.
| Property |
Description
| |
|---|
| Method |
Description
| Returns the number of output parameters returned by a stored procedure.
|
|
| |
|---|
watch and unwatch methods from Object.
close()
majorErrorCode and majorErrorMessage methods to interpret the cause of the error.
close method closes a stored procedure and releases the memory it uses. If you do not explicitly close a stored procedure with the close method, the JavaScript runtime engine on the server automatically closes it when the corresponding client object goes out of scope.
outParamCount()
outParameters, to ensure that the stored procedure has output parameters.
outParameters (n)
n |
outParamCount method before you call this method. If outParamCount returns 0, the stored procedure has no output parameters. In this situation, do not call this method.
You must retrieve result set objects before you call this method. Once you call this method, you can't get any more data from a result set, and you can't get any additional result sets.
Function.prototype.resultSet ()
resultSet method. See the description of the Resultset for restrictions on when you can use this method access the result sets for a stored procedure.
spobj = connobj.storedProc("getcusts");// Creates a new result set object
resobj = spobj.resultSet();
returnValue()
Last Updated: 11/13/98 10:23:53