Progress
SQL-92
Guide and Reference
INOUT and OUT Parameters When One Java Stored Procedure Calls Another
If an OUT or INOUT parameter is of data type CHARACTER, then getParam() returns a Java String Object. You must declare a procedure variable of type String, and explicitly cast the value returned by getParam to type String. Before calling getParam() you must call the SQLCursor.wasNULL method to test whether the returned value is null. If getParam() is called for a null value, it raises a DhSQLException.
The getParam() method returns the value of an INOUT or OUT parameter identified by the number you specify in the fieldIndex parameter. getParam() returns the value as an object of the datatype you specify in the fieldType parameter. Since getParam() returns the result as an instance of class Object, you must explicitly cast your inout_var variable to the correct datatype.
See the SQLCursor.getParam section in "Java Class Reference" for a complete description of syntax and parameters for the getParam method.
These are the general steps to follow when calling one Java stored procedure from another:
EXAMPLEThis example illustrates the steps required for calling one Java stored procedure from another:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |