Eclipse Community Forums: BIRT » Problem with Oracle sys

Home » Archived » BIRT » Problem with Oracle sys_refcursor

Problem with Oracle sys_refcursor [message #559471]

Thu, 16 September 2010 14:10

Eclipse User

I'm using Birt report 2.6 and I have a problem with sys_refcursor in procedure when this procedure are include in packge.

First I had built a simple procedure for test

CREATE OR REPLACE Procedure PRC_TEST(refcur OUT sys_refcursor)
is
Begin
open refcur for
SELECT NOM , PRENOM FROM TEST_UTILISATEUR;
end PRC_TEST;

In my report
{call prc_test(?)}
This work fine !!!

Now I try to include my prc in a package

CREATE OR REPLACE PACKAGE "PKG_TEST" IS
Procedure PRC_TEST(refcur OUT sys_refcursor);
END PKG_TEST;
/
CREATE OR REPLACE PACKAGE BODY "PKG_TEST" IS
Procedure PRC_TEST(refcur OUT sys_refcursor)
is
Begin
open refcur for
SELECT NOM , PRENOM FROM TEST_UTILISATEUR;
end PRC_TEST;
END PKG_TEST;
/

In my report
{call pkg_test.prc_test(?)}
This not work !!!

Give ORA-06550
PLS-00306 wrong number or types of arguments in call

Some one know why ?

Thanks for help.

[Updated on: Thu, 16 September 2010 14:23] by Moderator

Re: Problem with Oracle sys_refcursor [message #559690 is a reply to message #559471]

Fri, 17 September 2010 11:02

Eclipse User

Can you post the log file?

Jason

On 9/16/2010 2:10 PM, St wrote:
> I'm using Birt report 2.6 and I have a problem with sys_refcursor in
> procedure when this procedure are include in packge.
>
> First I had built a simple procedure for test
>
> CREATE OR REPLACE Procedure PRC_TEST(refcur OUT sys_refcursor)
> is
> Begin
> open refcur for
> SELECT NOM , PRENOM , unite_administrative FROM PIL_INFO_UTILISATEUR;
> end PRC_TEST;
>
> In my report {call prc_test(?)} This work fine !!!
>
> Now I try to include my prc in a package
> CREATE OR REPLACE PACKAGE "PKG_TEST" IS
> Procedure PRC_TEST(refcur OUT sys_refcursor);
> END PKG_TEST;
> /
> CREATE OR REPLACE PACKAGE BODY "PKG_TEST" IS
> Procedure PRC_TEST(refcur OUT sys_refcursor)
> is
> Begin
> open refcur for
> SELECT NOM , PRENOM , unite_administrative FROM PIL_INFO_UTILISATEUR;
> end PRC_TEST;
> END PKG_TEST;
> /
>
> In my report {call pkg_test.prc_test(?)} This not work !!!
>
> Some one know why ?
> Thanks for help.
>
>
>

Re: Problem with Oracle sys_refcursor [message #636186 is a reply to message #559690]

Fri, 29 October 2010 10:57

Eclipse User

I have no log file ... but I just want to know why when I use procedure my script work well and when I put the same procedure in package is not work.

Re: Problem with Oracle sys_refcursor [message #636213 is a reply to message #636186]

Fri, 29 October 2010 12:06

Eclipse User

Can you log a bug for this?

Jason

On 10/29/2010 10:57 AM, St wrote:
> I have no log file ... but I just want to know why when I use procedure
> my script work well and when I put the same procedure in package is not
> work.

Previous Topic:	[Solved] fetch script and preview
Next Topic:	Programmatic manipulation of report designs

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 21:53:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter