Re: Using pipelined functions

Carlos Correia wrote:

> The function does contain logical segmentation ... my current concern
> is that i am 1/5 through writing the function. So this function could
> potentially hit 1000 lines.
> Also i've now tested the method I suggested in my first post, I seem to
> have hit a limitation in that im not able to do the following
>
> call this line from another stored procedure
>
> open cur0 for 'SELECT * FROM TABLE(FP_NEWFORMAT(:1,:2))' USING a,b;
>
> apparently you cant use the above syntax so i've had to do the
> following
>
> open cur0 for 'SELECT * FROM TABLE(FP_NEWFORMAT('''||a||''','||b||')';
> any ideas ?

I've yet to ever have the need to write that many lines in any single object except perhaps a very large package or type body.

Perhaps you need to go back to basics and look at your design. It smells the same as a post in which someone claims their table has hundreds of columns.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---