Re: Alternate methods for multiple rows input/output to a function.

2019-05-28 Thread Adrian Klaver
On 5/28/19 8:06 AM, RAJIN RAJ K wrote: Please reply to list also. Ccing list. Thanks for the response. CTE is not useful in my case. Here i want to pass the table to a function and get the filtered results back from the function. I tried few but not use full. 1. Pass table input --> Ref curs

Re: Alternate methods for multiple rows input/output to a function.

2019-05-28 Thread Adrian Klaver
On 5/28/19 7:36 AM, RAJIN RAJ K wrote: --> Function ' filter_id ' filters the ID's based on some conditions. --> Input is set of ID's. (Not directly taking the input since there is no provision to pass multiple rows to a function) To be honest I cannot follow what you are trying to achieve bel