ORACLE PROCEDURE

SQL>sqlplus scott/tiger@orcl

SQL>EDIT salary

 

CREATE or REPLACE PROCEDURE salary (id_new IN NUMBER, sal IN NUMBER)

IS

BEGIN

    UPDATE emp

    SET salary = sal

    WHERE id = id_new;

    COMMIT;

END salary;

/

 

SQL>@salary

 

SQL>EXEC salary(120, 100000); 

 

SQL>SHOW ERRORS --> error발생시