Eclipse Community Forums: BIRT » Calling oracle stored procedures.

Help

Home

Home » Archived » BIRT » Calling oracle stored procedures.

Show: Today's Messages :: Show Polls :: Message Navigator

Calling oracle stored procedures. [message #64258]

Wed, 03 August 2005 20:53

marko

Messages: 39
Registered: July 2009

Member

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

Thank you.

Report message to a moderator

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

Mon, 08 August 2005 18:20

marko

Messages: 39
Registered: July 2009

Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 16 17:31:03 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter