Eclipse Community Forums: BIRT » How to use Oracle stored procedure in BIRT

Home » Archived » BIRT » How to use Oracle stored procedure in BIRT

How to use Oracle stored procedure in BIRT [message #150470]

Mon, 03 April 2006 16:33

Eclipse User

Originally posted by: Puttappaiah.muni.pss-systems.com

Hi,
We are evaluating the BIRT to be used as our reporting framework. We use
Oracle as the database. I am not able to find a way to use stored
procedures written in Oracle to be used as data set.
These stored procedures uses Ref Cursor as INOUT parameter. I am not able
to set the ref cursor as the parametr type.
Any help will be highly appreciated.
Thanks
Muni

Re: How to use Oracle stored procedure in BIRT [message #150572 is a reply to message #150470]

Tue, 04 April 2006 06:04

Eclipse User

Originally posted by: r.budner.abg.com.pl

Muni napisał(a):
> Hi,
> We are evaluating the BIRT to be used as our reporting framework. We use
> Oracle as the database. I am not able to find a way to use stored
> procedures written in Oracle to be used as data set.
> These stored procedures uses Ref Cursor as INOUT parameter. I am not
> able to set the ref cursor as the parametr type. Any help will be highly
> appreciated.
> Thanks
> Muni
>
Read this:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=117166

Robert

Re: How to use Oracle stored procedure in BIRT [message #150648 is a reply to message #150470]

Tue, 04 April 2006 09:59

Eclipse User

I have high hopes of writing an extension to the jdbc ODA for 2.1 that
will work against Oracle Ref Cursors. I am still waiting a bit for the
2.1 build to stabilize before I do this. Keep an eye on BirtWorld
(birtworld.blogspot.com) I will post there when it is complete.

If anyone else takes this one on, please let me know. I would be
interested to hear how it goes.

Scott Rosenbaum
BIRT PMC

Muni wrote:
> Hi,
> We are evaluating the BIRT to be used as our reporting framework. We use
> Oracle as the database. I am not able to find a way to use stored
> procedures written in Oracle to be used as data set.
> These stored procedures uses Ref Cursor as INOUT parameter. I am not
> able to set the ref cursor as the parametr type. Any help will be highly
> appreciated.
> Thanks
> Muni
>

Re: How to use Oracle stored procedure in BIRT [message #150695 is a reply to message #150648]

Tue, 04 April 2006 11:24

Eclipse User

Originally posted by: Puttappaiah.muni.pss-systems.com

Hi,
Thanks for the info. In any way, if we can write this on our own, we will
be glad to contribute too. Please let us know.
thanks
Muni

Previous Topic:	parameter variable
Next Topic:	What are the jar files at mininum I need to include to use chart library

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Aug 28 18:55:28 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter