Sure. Here's what the doc says:
The supported syntax to call a stored procedure is shown below. It is recommended that you use the syntax below instead of the previously supported CALLORA syntax.
ENGINE SQLORA
EX SAMPLE PARM1,PARM2,PARM3...;
TABLE FILE SQLOUT
END
The server supports invocation of stored procedures written according to the following rules:
. All scalar parameters (IN, OUT, and INOUT) are supported.
. A cursor must be defined with:
The TYPE statement in a PACKAGE or PROCEDURE.
An associated record layout of the answer set to be returned.
. The cursor must be opened in the procedure.
. No fetching is allowed in the stored procedure. The Adapter for Oracle fetches the answer set.
. Any messages must be issued using the RAISE APPLICATION ERROR method.
Note: Any application error that is issued by the stored procedure is available in the server variable &ORAMSGTXT.
