Executing an Oracle Stored procedure with a DATE

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/992107852

October 05, 2009, 04:34 PM

Kowens

Executing an Oracle Stored procedure with a DATE

I have an oracle stored procedure that has the following input parameters:
DATE
Integer

and gets a DATE as an output parm.

Runs great in PL/SQL.
Webfocus is having a hard time recognizing the DATE field and also an output parm. Any suggestions?

Version: 8.0.0.6
Windows platform
All output formats will probably be used.

October 05, 2009, 04:53 PM

Francis Mariani

Did you read this:

Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS V7.6.1 > Using the Adapter for Oracle > Reporting Against an Oracle Stored Procedure

Or

Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS V7.6.1 > Using the Adapter for Oracle > Calling an Oracle Stored Procedure Using SQL Passthru

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

October 06, 2009, 08:46 AM

Kowens

Still doesn't work.

I have 2 input parameters, one a date the other a number. I have 1 output parameter that is a date. Not sure how to define the output parameter.

Version: 8.0.0.6
Windows platform
All output formats will probably be used.