Pure JavaScript

Connection.storedProc()

NES3+Syntax

connection.storedProc(procName)
connection.storedProc(procName, arg1, arg2, … , argN)

Description

The storedProc() method of the Connection object creates a Stproc object that allows you to execute a database-specific stored procedure using the connection from which it was invoked.

As shown in the syntactical definition, you can also pass any arguments needed to the method for processing. If you are using a stored procedure that requires arguments, or if you want to have the procedure run using default arguments, you must pass /Default/ as the argument. The following shows an example of passing a default value:

var myStproc = myConn.storedProc("sp_employees", "/Default/");

The scope of this procedure ...