How to load many parameter input into PL/SQL Procedure ?

[plammy]

Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.

update employee
set emp_name = &a
,emp_salary = &b;

Thank you very much.

[andrejm]

How to load many parameter input into PL/SQL Procedure ?
Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.

update employee
set emp_name = &a
,emp_salary = &b;

CREATE OR REPLACE PROCEDURE upd_emp_proc(param_emp_name IN VARCHAR2, param_emp_salary IN NUMBER) IS
BEGIN
UPDATE employee
SET emp_name = param_emp_name,
emp_salary = param_emp_salary
WHERE EMPLOYEE_ID = whatever(parameter?);
END upd_emp_proc;