SQL*Plus Tutorial


SqlPlus call Pl/SQL procedure

To call and use Oracle Pl/SQL procedure in SQLPlus you must use EXEC command. The commit is done when you use the EXIT command to exit from SQL*Plus session.

SQLplus Pl/SQL procedure



EXEC add_info(7,'xyz');

EXEC add_info(8,'abc');