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;