PL/SQL,提示编译异常:创建的过程带有编译异常

PL/SQL,提示编译错误:创建的过程带有编译错误
点击右边红色标题查看本文完整版：PL/SQL,提示编译错误:创建的过程带有编译错误

CREATE OR REPLACE function SqGetData(ppid IN VARCHAR2) RETURN VARCHAR2 IS
  DECLARE
  varResult VARCHAR2(1024);
  varBloodNo VARCHAR2(32);
  varSex VARCHAR2(32);
  varSexN VARCHAR2(32);
  varName VARCHAR2(32);
  varBirthday VARCHAR2(32);
  varPassportid VARCHAR2(32);
  varExamdate VARCHAR2(32);
  varToday VARCHAR2(32);
  varTodayN VARCHAR2(32);
 
  BEGIN
  varToday := TO_CHAR(SYSDATE, 'yyMMdd ');
  varTodayN := TO_CHAR(SYSDATE, 'yyyy-MM-dd ');
  varBloodNo := varToday || ppid;
  select SURNAME,SEX,TO_CHAR(BIRTHDAY, 'yyyy-MM-dd '),PASSPORT_ID,TO_CHAR(EXAM_DATE, 'yyyy-MM-dd ') into varName,

varSex, varBirthday, varPassportid, varExamdate from EXAM_CXDJ as a, EXAM_RECORD as b where a.BLOOD_NO = varBloodNo and

a.EXAM_NO = b.EXAM_NO;

  IF varSex = '0 ' THEN
  varSexN := '男 ';
  ELSE
  varSexN := '女 ';
  END IF;

  varResult := '1, '||varName|| ', '||varSexN || ', '||varBirthday|| ', '|| 'ID0,ID0,ID0,ID0,ID0,ID0,ID0, , ' || varPassportid

|| ', '||varExamdate|| ', '||varTodayN|| ', , ,ID0,ID0, , ';

  return varResult ;
  EXCEPTION