Try :
Select Normalised_event_ID,
A_Party_Id,
B_Party_Id,
Full_Path,
Name
from
Normalised_event,
tblOperator
where
Substr(B_Party_Id(+),1,length(code)) = code
and trim(full_path) = '107'
order by Normalised_event_ID
Do let know if it works ....
You can use Parameterized Cursor. Make the second cursor parameterized: CURSOR your_cursor(var_emp_id number) is select * from your_table where emp_id = var_emp_id;
Then while opening this cursor pass the emp_id from first cursor.
Reply if you need more details.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.