Oracle的function

写在这里，以便于以后忘记格式后可以查询。

CREATE OR REPLACE FUNCTION TEMP_FUNC_WYL(PI_AAA100 VARCHAR2,

                                         PI_AAA102 VARCHAR2)

--字典转换，把代码值转换成对应的可理解的中文,wyl,20141105

 RETURN VARCHAR2 IS

  V_AAA103 VARCHAR2(1000);

BEGIN

  SELECT AAA103

    INTO V_AAA103

    FROM AA10 A

   WHERE A.AAA100 = PI_AAA100

     AND A.AAA102 = PI_AAA102;

  RETURN V_AAA103;

EXCEPTION

  WHEN NO_DATA_FOUND THEN

    DBMS_OUTPUT.PUT_LINE('没有找到数据');

END;