CREATE OR REPLACE FUNCTION p_proposal(pol IN VARCHAR2) RETURN VARCHAR2 IS result VARCHAR2(100); BEGIN SELECT CASE WHEN proposal_no = pol THEN 'yes' ELSE 'no' END INTO result FROM proposal_sec1 WHERE proposal_no = pol; RETURN result; END p_proposal; / I need calling function query