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:
Post a Comment