Eclipse Community Forums: BIRT » Oracle stored procedure and/or function

Home » Archived » BIRT » Oracle stored procedure and/or function

Oracle stored procedure and/or function [message #146024]

Mon, 20 March 2006 11:19

Eclipse User

Hello,

I am using the latest stable build from BIRT rcp
(birt-rcp-report-designer-S20051110).

I am trying to use an oracle function as a dataset.

my function is looking like this :

FUNCTION MYFUNC(urlpattern in varchar2)
RETURN types.ref_cursor
AS
site_cursor types.ref_cursor;
BEGIN
OPEN site_cursor FOR
SELECT url from website
WHERE url like urlpattern;
RETURN site_cursor;
END;

I cannot manage to call this function from BIRT. Any help would be
appreciated.

ps : I also tried using a stored procedure with an output parameter but it
does not work better.

Thanks,
Sebastien

Re: Oracle stored procedure and/or function [message #146086 is a reply to message #146024]

Mon, 20 March 2006 13:49

Eclipse User

Sebastien,
Can you file a bugzilla bug for this issue?
thanks,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Sebastien" <sebastien.lemeunier@novartis.com> wrote in message
news:b9468e6843502cbf6d988972dec9f23a$1@www.eclipse.org...
> Hello,
>
> I am using the latest stable build from BIRT rcp
> (birt-rcp-report-designer-S20051110).
>
> I am trying to use an oracle function as a dataset.
>
> my function is looking like this :
>
> FUNCTION MYFUNC(urlpattern in varchar2)
> RETURN types.ref_cursor
> AS
> site_cursor types.ref_cursor;
> BEGIN
> OPEN site_cursor FOR
> SELECT url from website
> WHERE url like urlpattern;
> RETURN site_cursor;
> END;
>
> I cannot manage to call this function from BIRT. Any help would be
> appreciated.
>
> ps : I also tried using a stored procedure with an output parameter but it
> does not work better.
>
> Thanks,
> Sebastien
>

Re: Oracle stored procedure and/or function [message #146406 is a reply to message #146086]

Tue, 21 March 2006 05:51

Eclipse User

Ok I will.
Thanks.

Previous Topic:	BIRT 2 : vertical cells span
Next Topic:	Format Number, Can not work in Data (BIRT 2.0) ?

Goto Forum:

-=] Back to Top [=-

Current Time: Mon May 12 10:00:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter