SQL Plus Tutorial

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');