Eclipse Community Forums: BIRT » Maximo BIRT with Stored Procedure

Home » Archived » BIRT » Maximo BIRT with Stored Procedure(Running BIRT Report with Stored Procedure in Oracle DB using DBLink)

Maximo BIRT with Stored Procedure [message #1795332]

Thu, 20 September 2018 09:07

Eclipse User

A stored procedure from Oracle GL needs to be called from BIRT 4.3.1 in Maximo 7.6, which has an Input and Output parameter.

Running in SQL developer with DBMS Output gives results successfully

declare
amts number;
begin
UTILS.GETBUDGET@CHECKBUDGET('00-11-1245-875666-00000-00-0000-0000',amts);
DBMS_OUTPUT.PUT_LINE('Budget is : ' || amts);
end;

I am trying to run the same in BIRT report where the output parameter amts needs to be displayed.

1) Not getting enough clarity if within the scripted Datasource can a procedure be called.
2) Next if we create a separate JDBC Datasource then how to use the output parameters to display it in the report

[Updated on: Sun, 23 September 2018 08:39] by Moderator

Re: Maximo BIRT with Stored Procedure [message #1795459 is a reply to message #1795332]

Sun, 23 September 2018 08:37

Eclipse User

I was able to figure out and run the SQL Procedure using an external JDBC Datasource, which works and gives result too.

Now the question being can this external JDBC Datasource be used when running the report within Maximo, if yes then is there any additional parameters for a JDBC Datasource to work from Maximo. My report gives report when run outside Maximo, but running after import into Maximo gives an Error that Cannot find the ODA dataSource extension (org.eclipse.birt.report.data.oda.jdbc)

Previous Topic:	iDataExtract.getResultSetList() gives empty list
Next Topic:	buglist

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Mar 22 10:44:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter