oracle 存储过程对于传参数是字符串标识符无效的解决办法

　　oracle 存储过程对于传参数是字符串标识符无效的解决办法

　　create or replace function f_get_add_month(Ls_jjxlbm Varchar2) return varchar2 is

　　Ls_pdcode varchar2(300);

　　ls_result varchar2(200);

　　begin

　　select ''|| Ls_jjxlbm || '' into ls_result from dual;

　　Select aaa005 Into Ls_pdcode From aa01 where aaa001=ls_result;

　　Return Ls_pdcode;

　　Exception

　　When Others Then

　　Ls_pdcode:='';

　　Return Ls_pdcode;

　　end f_get_add_month;

　　-------------------------------------------------

　　Select * From aa01 where aaa001=MEDICAL_CX_JM_SY;

　　Select * From aa01 where aaa001='MEDICAL_CX_JM_SY';

　　------------------------------------------------