Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PIPE ROW DATA STORED TO VARIABLE

Mahendran PJul 28 2023 — edited Jul 28 2023

CREATE OR REPLACE FUNCTION ac_data (p_id IN VARCHAR)
RETURN tab_state
PIPELINED
AS
ac_data tab_state;
out_data tab_state;

 CURSOR ac\_c   
 IS  
      SELECT \*  
        FROM EMPLOYEE\_DETAILS  
       WHERE     ID = p\_id                    

BEGIN
FOR ac_data IN ac_c
LOOP
PIPE ROW ( (ac_data));
END LOOP;
END ac_data ;

Here how will store the pipe row data to another variable?. I need count of ac_data.

Comments
Post Details
Added on Jul 28 2023
1 comment
233 views