oracle - how to apply parameters in this procedure? -


How do I apply this parameter as my_email and my_salary as OUT:

  Create or change functionalities FYI_CENTER as My_email employees. Email% TYPE; ** ** my_salary employees.salary% TYPE; - ** Outside parameter ** Select Start Email, pay in my_email, employees to employees WHERE employee_id = 101; DBMS_OUTPUT.PUT_LINE ('My Email =' || my_email); DBMS_OUTPUT.PUT_LINE ('My salary =' my_salary); End;  

You can not return a value to the IN parameter. What is the suspicion to me, this is a general purpose process:

take action or take action again FYI_CENTER (Type employee / id% in p_employee_id, exit employees, enter email Please, send email, type, p_slari.start% TYPE) Start as email, pay p_email, p_salary employees WHERE employee_id = p_employee_id; End; /

... which you can call again like this:

  Announce my_email employee. Email% TYPE; ** ** my_salary employees.salary% TYPE; - ** Outside parameter ** BEGIN Fei_Centre (101, my_email, my_salary); DBMS_OUTPUT.PUT_LINE ('My Email =' || my_email); DBMS_OUTPUT.PUT_LINE ('My salary =' my_salary); End; /  

Comments