mohammed.sardar Posted September 12, 2014 Share Posted September 12, 2014 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now