SQL & PL/SQL

Hi

I have a stored procedure (P1) that returns a ref cursor as the output.

Another procedure (P2) receives this ref cursor (C).

In this procedure (P2), I want to do a Bulk Collect from this ref cursor (C) in
a table type variable that has been declared locally in the procedure P2. I have created appropriate Object Type and Table Types at the database level.

Please advise how to do it. I tried to do it in different ways, but was not able to do it - each time I faced incompatible data-type related issues.

Regards
Madhup