Resolved: Getting Null as the result from all stored procedure queries including the assignment too.
Thanks for reaching out.
e.first_name=p_last_name instead of
e.last_name=p_last_name. Correcting this will give you the correct result set.
Hope this helps.
Yes, I corrected that but still, I am getting OK as the result not only from this query but also for the queries related to stored procedures and functions. Is there any specific reason behind this?