Pure JavaScript

Stproc.returnValue()

NES3+Syntax

							stproc.returnValue()

Description

The returnValue() method of the Stproc object returns the return value of the stored procedure. For DB2, Informix, and ODBC, this method always returns null. Oracle only returns null if the stored procedure did not return a value. Sybase always returns a value.

Note

Before you call this method, you must retrieve any Resultset objects. Once this method is called, no more data can be obtained from the current result set and no more result sets can be created.

Example

Listing 8.148 calls a stored procedure, creates a result set, and obtains the result value. This value is then written to the user's page.

Listing 8.148 Accessing a Stored Procedure's Return Value

<SERVER> // ...