Eclipse Community Forums: BIRT » Calling oracle stored procedures.

Home

Home » Archived » BIRT » Calling oracle stored procedures.

Calling oracle stored procedures. [message #64258]

Wed, 03 August 2005 16:53

Eclipse User

Is there any support for specifying queries to oracle stored procedures that
return a resultset (cursor)?

Thank you.

Re: Calling oracle stored procedures. [message #65733 is a reply to message #64258]

Mon, 08 August 2005 14:20

Eclipse User

It would be nice to hear from the BIRT team regarding support for calling
stored procs/functions.

At least for Oracle, i found a workaround using Oracle table functions.

Here is a discussion.
http://www.databasejournal.com/features/oracle/article.php/2 222781

Basically a wrapper that allows functions that return resultsets to be used
in select statements.

eg.
SQL> SELECT * from TABLE(func('param1','param2'));

"Marko" <mmilicevic@pssd.com> wrote in message
news:dcrap1$hro$1@news.eclipse.org...
> Is there any support for specifying queries to oracle stored procedures
that
> return a resultset (cursor)?
>
> Thank you.
>
>

Previous Topic:	BIRT 1.0.1 Release
Next Topic:	Could not find framework after ugrading BIRT t 1.01

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 12:54:53 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter