Eclipse Community Forums: BIRT » ORA-02089 only in BIRt

Home » Archived » BIRT » ORA-02089 only in BIRt

ORA-02089 only in BIRt [message #740453]

Tue, 18 October 2011 10:28

Eclipse User

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 14:44

Eclipse User

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]

Tue, 18 October 2011 21:11

Eclipse User

ojdbc14 - oracle 10g
birt 3.7

[Updated on: Tue, 18 October 2011 21:13] by Moderator

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 18:20:48 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter