Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problem with Oracle sys_refcursor
Problem with Oracle sys_refcursor [message #559471] Thu, 16 September 2010 18:10 Go to next message
St is currently offline St
Messages: 2
Registered: September 2010
Junior Member
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 18:23]

Report message to a moderator

Re: Problem with Oracle sys_refcursor [message #559690 is a reply to message #559471] Fri, 17 September 2010 15:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 14:57 Go to previous messageGo to next message
St is currently offline St
Messages: 2
Registered: September 2010
Junior Member
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 16:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Wed Oct 01 14:31:20 GMT 2014

Powered by FUDForum. Page generated in 0.07850 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software