How You Can Pass Parameters to and From Database Procedures
You use parameter names to pass parameters to database procedures just as you do with 4GL procedures. You can pass the parameters in any order. For database procedures, the parameters must be simple variables only.
In the following example, intparam, floatparam, and charparam are integer, float, and varchar variables, respectively:
returnvalue = callproc mydbprocedure(intparam = 256,
floatparam = 3.625,
charparam = 'seen any good movies lately');
When the procedure returns a value, you must specify an integer variable in the calling frame or procedure to receive the return value, for example:
returnvalue = integer;