Need to EXEC an Oracle Procedure From Within WebFOCUS
Need to EXEC an Oracle Procedure From Within WebFOCUS
(OP)
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
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 
Talk To Other Members
RE: Need to EXEC an Oracle Procedure From Within WebFOCUS
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.