Problem with Oracle sys_refcursor [message #559471] |
Thu, 16 September 2010 18:10 |
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 |
|
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 #636213 is a reply to message #636186] |
Fri, 29 October 2010 16:06 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.04938 seconds