Jump to content
Changes to the Jaspersoft community edition download ×

Jasper and PlSQL


mohammed.sardar

Recommended Posts

Hi All, 

 

 

 

I have done with designing a Jasper Report. Have called a PL/SQL as below .select * from TABLE(package_name.function_name(arg1,arg2). which in turn returns a TABLE of data through a TYPE funciton. AS pipeline(row), when I consult for some justification on the below pl/sql function go the response to avoid using PIPELINE function  as will cause some performance issue. 

 

 

 

--trim(pmrow.part_number) is null then

 

        raise partmaster_block;

        end if;

        pipe row(pmrow);

        end loop;

        exception

                --when others then

                when partmaster_block then

                pmrow.part_number := null;

                pmrow.part_description := null;

                pmrow.part_type := null;

                pmrow.stock_group := null;

                pmrow.uom := null;

                pmrow.block_status := null;

        return;

        end;

I'm advised to avoid this and us the ref_cursor to return data to Jasper. My doubt is is there any other way to fetch data for export from oracle other than the abvoe.  Please help me thanks

 

 

 

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...