	JavaScript Programmer's Reference
Prev	Home	Up		Next

Stproc object (Object/NES)

An object that encapsulates a call to a stored procedure on a database from a Netscape Enterprise Server.

Availability:

JavaScript - 1.2

Netscape Enterprise server - 3.0

JavaScript syntax: NES myStproc = database.storedProc(aProcName, aProcParm);

NES myStproc = myConnection.storedProc(aProcName, aProcParm)

Argument list: aProcName The name of a stored procedure to call

aProcParm A parameter value to pass to the stored procedure

Object properties: prototype

Object methods: close(), outParamCount(), outParameters(), resultSet(), returnValue()

This object provides a container to manage the call to the stored procedure and somewhere that the results can be made available for further processing by your scripts.

You create Stproc objects by requesting them from the database or connection objects that are accessing the target database you are interested in.

Example code:

   <SERVER>

   // An example derived from Wrox Professional JavaScript

   database.connect("ODBC", "myDatabase", "me", "myPassword", "");

   myStproc = database.storedProc("myProcedure", 40);

   </SERVER>

See also: Connection.storedProc(), Netscape Enterprise Server

Property	JavaScript	JScript	N	IE	Opera	NES	ECMA	DOM	CSS	HTML	Notes
`prototype`	1.2					3.0					-

Method	JavaScript	NES	Notes
`close()`	1.2	3.0	-
`outParamCount()`	1.2	3.0	-
`outParameters()`	1.2	3.0	-
`resultSet()`	1.2	3.0	-
`returnValue()`	1.2	3.0	-

Prev	Home	Next
Storage duration	Up	Stproc.close()
JavaScript Programmer's Reference, Cliff Wootton Wrox Press (www.wrox.com) Join the Wrox JavaScript forum at p2p.wrox.com Please report problems to support@wrox.com © 2001 Wrox Press. All Rights Reserved. Terms and conditions.

JavaScriptProgrammer'sReference

Stproc object (Object/NES)

Example code:

JavaScript
Programmer's
Reference