Need to EXEC an Oracle Procedure From Within WebFOCUS

[LeonelSanchezJr]

We have a PROCEDURE which resides in Oracle.
We want to perform an EXEC of this procedure from
a Webfocus FEX.

Can this be done?

We can do it for Stored Procedures which reside in MS SQL

Thanks,

Leo ;-)

 

[focwizard]

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.