Last answered:

06 Dec 2023

Posted on:

01 Dec 2023

0

Resolved: Getting Null as the result from all stored procedure queries including the assignment too.

4 answers ( 1 marked as helpful)
Instructor
Posted on:

01 Dec 2023

0

Hi Maimuna!
Thanks for reaching out.


You used 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.
Best,
Tsvetelin

Posted on:

01 Dec 2023

0

Posted on:

01 Dec 2023

0

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? 

Instructor
Posted on:

06 Dec 2023

0

Hi Maimuna!
Thanks for reaching out!


Could you please support your question with the entire code of the f_emp_info() stored procedure? This can help us assist you better. Thank you.


Looking forward to your answer.
Best,
Tsvetelin

Submit an answer