Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 vaFriend
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

Report message to a moderator

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 WeathersbyFriend
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

Report message to a moderator

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 vaFriend
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:29:04 GMT 2024

Powered by FUDForum. Page generated in 0.04122 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly