PL/SQL Sqlerrm
Oracle PL/SQL Sqlerrm Example
DECLARE
var customers%rowtype;
BEGIN
Select *
Into var
From customers c
Where c.customer_type='CC';
dbms_output.put_line('NAME: '||var.customer_type);
EXCEPTION
WHEN Others THEN
dbms_output.put_line('Sqlerrm message is:'||SQLERRM);
Raise;
END;