Thursday 6 March 2008

PL-SQL example with exception handling

DECLARE
searchKey VARCHAR2(100) := '';
valueFound NVARCHAR2(2000);
BEGIN

SELECT value INTO valueFound
FROM cmn_cf_configuration
WHERE key = searchKey;

dbms_output.put_line('Search key : ' || searchKey || ' returned ' || valueFound);
EXCEPTION
WHEN NO_DATA_FOUND
THEN dbms_output.put_line('Search key : ' || searchKey || ' returned no data');
WHEN OTHERS
THEN RAISE_APPLICATION_ERROR(-20011, 'Unknown error');
END;

No comments: