Not able to post my question

[mohammed.sardar]

when I try to raise my doubt as below getting the below error and now allowed to post . Any help please?

 

Your submission has triggered the spam filter and will not be accepted.
If you feel this is in error, please try rephrasing the post title and/or body.

Your submission has triggered the spam filter and will not be accepted.
If you feel this is in error, please try rephrasing the post title and/or body.

 

********************************

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

 

 

 

 

 

[djohnson53]

We're sorry that you had problems with our Anti-Spam system.

It's suspicious of new users, but we'll mark you as a contributor and you won't have this problem again.