To run a stored procedure you can use the CALL command like a function or run the CALL command at the R> Prompt.
Use the CALL command like a function with the following syntax:
SET VAR v1 = (CALL procname(arglist))
Run the CALL command from the R> Prompt with the following syntax:
CALL procname(arglist)
When the CALL command is run at the R> Prompt, the return value from the stored procedure is placed in the variable STP_RETURN. The return value can be an expression.
procname
The procedure name.
arglist
The argument values separated by commas. An arglist must always be used, even if empty. For example:
SET VAR v1 = (CALL procname ( )).
