Using/Calling a cursor in another cursor - PL/Sql
- by Cindy
I have a function with a cursor which returns an ID. I need to get some fields in another cursor using this ID result from the first cursor.
So my first cursor is:
CREATE OR REPLACE function get_id(id number)
CURSOR child_id
IS
SELECT table1_id
FROM table1,child
WHERE child_id = id
AND table1_id =…