Unable to call stored proc

I am trying to invoke stored proc which has no input parameter but I get below mentioned error.

Query - { ? = call PLA_ORA_DBA.CPRGETLASTUPDATEDATE_PLA()}
I have set the parameter as output parameter.
Preview result gives me following error:

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.0.v20080606
Error Code:odaconsumer.CannotExecuteStatement
Error Message:Cannot execute the statement.
SQL statement does not return a ResultSet object or an update count.
SQL error #1: OALL8 is in an inconsistent state.

Any thoughts/suggestions?

Find more posts tagged with

Comments

rmurphy

Oracle's JDBC Driver does not return a standard java.sql.ResultSet when dealing with stored procedures. You will need to use a JDBC Driver that conforms to the JDBC specification and returns a ResultSet. 
 
The Actuate BIRT Report Designer Professional includes a set of DataDirect JDBC drivers that includes an Oracle driver which will return a ResultSet object from a Stored Procedure. 
 
You can download a trial copy of the designer from here: 
<a class='bbc_url' href='http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=238'>Actuate BIRT Report Designer Pro for Windows, Release 10.0 - Downloads - BIRT Exchange</a> 
 
Rob

vlodha

It works with appropriate drivers but now I get following error

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.1.v20080829
Error Code:data.engine.ColumnBindingReferToInexistColumn
Error Message:Column binding "ITEM" has referred to a data set column "ITEM" which does not exist.

rmurphy

Sounds like you have changed the data binding to you Table element, and the new binding does not have ITEM defined.

Select your table, and then select the Binding tab in the Property Editor view in the bottom section of the IDE. Inside there, you will see all the bindings that exists for the table. If it doesn't exist, you can create it.

Rob

vlodha

Its resolved now. I can see the report rendered by invoking stored proc using default parameters. How do I pass parameters from jsp ? I surfed on the net but did not get any helpful answers.