Progress
SQL-92
Guide and Reference


SQLCursor.registerOutParam

Register OUT parameters.

Format

registerOutParam( int fieldIndex, short fieldType [ , short scale ] )

Returns

None

Parameters
fieldIndex

An integer that specifies the position of the parameter in the parameter list.

fieldType

A short integer that specifies the datatype of the parameter. The allowable defined values for fieldType are listed in Table 6–4, grouped by category of data type:

Table 6–4: Allowable Values for fieldType in registerOutParam 
Character
Exact Numeric
Approximate Numeric
Date-time
Bit String
CHAR
INTEGER
REAL
DATE
BIT
CHARACTER
SMALLINT
FLOAT
TIME
BINARY
VARCHAR
TINYINT
DOUBLE
TIMESTAMP
VARBINARY
NUMERIC
LVARBINARY
DECIMAL

Throws

DhSQLException

See the "INOUT and OUT Parameters When One Java Stored Procedure Calls Another" section in "Java Stored Procedures and Triggers" for an example of how and when to use SQLCursor.registerOutParam().


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095