Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
how to call sys_refcursor in birt
Migrateduser
hi friend,
i m using procedure in my birt report.my procedure has 3 input parameter and one is out parameter. the out parameter is sys_refcursor type.
for exmple--
create or replace procedure gps_procedure(branchcode in varchar2,
fromdate in varchar2,
group1 in varchar2,
par_employee out sys_refcursor)
this procedure working fine and given me right data.
as i m using this procedure in my java application to build birt report,i have to send the parameter value through my application
in java i m set the value for input parameter for procedure as..
task.setParameterValue("branchcode",orgstrcode);
task.setParameterValue("fromdate",fromdate1);
task.setParameterValue("group",group1);
task.setParameterValue("PAR_EMPLOYEE",oracle.jdbc.OracleTypes.CURSOR);
and i set value for sys_refcursor as task.setParameterValue("PAR_EMPLOYEE",oracle.jdbc.OracleTypes.CURSOR);
but this is not working it give me error in birt report
"wrong number or types of arguments in call to 'GPS_PROCEDURE'"
thats mean sys_refcursor value wich i set is wrong.
so can any one tell me that what or how i can set value for sys_refcursor in my java code application.
thanks
Find more posts tagged with
Comments
There are no comments yet