Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » ORA-02089 only in BIRt
ORA-02089 only in BIRt [message #740453] Tue, 18 October 2011 14:28 Go to next message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
I am calling an oracle stored procedure from BIRT to get data. Outside of BIRT we get the results properly, but when we are running the SP with the same parameters in BIRT we are getting the following error.

java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session

Should we set auto commit to false? if we do have to do that, how do we do in the script. like below...

this.setExtensionProperty("odaJndiName", "this.test.jndi");

Thanks
Re: ORA-02089 only in BIRt [message #740646 is a reply to message #740453] Tue, 18 October 2011 18:44 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

What version of the Oracle driver are you using?

Jason

On 10/18/2011 10:28 AM, sam wrote:
> java.sql.SQLException: ORA-0208
Re: ORA-02089 only in BIRt [message #740882 is a reply to message #740453] Wed, 19 October 2011 01:11 Go to previous message
sam va is currently offline sam va
Messages: 121
Registered: July 2011
Senior Member
ojdbc14 - oracle 10g
birt 3.7

[Updated on: Wed, 19 October 2011 01:13]

Report message to a moderator

Previous Topic:Enabling client-side JavaScript
Next Topic:best practices to reduce the size of rptdocument?
Goto Forum:
  


Current Time: Wed Sep 03 00:06:26 GMT 2014

Powered by FUDForum. Page generated in 0.01602 seconds