我要使用以下输入参数执行此过程。

DECLARE  
    in_fieldname_list VARCHAR2(4000);  
    L_FILE_NAME VARCHAR(200);  
 
 
    BEGIN  
 
    in_fieldname_list := 'PROPTYPE'', ''ADDR1'', ''CITY'', ''STATE'', ''ZIP'', ''OAPPRAISAL';  
 
    pack_audit_trail_report.SP_AUDIT_TRAIL (  
        'B',  
        'LEH005',  
        NULL,  
        NULL,  
       in_fieldname_list,  
        '12/10/2012',  
        '01/15/2013',  
        L_FILE_NAME);  
    END; 

Error report: 
: missing right parenthesis 
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909 
ORA-06512: at "SYS.DBMS_SQL", line 39 
ORA-06512: at "CDM.PACK_AUDIT_TRAIL_REPORT", line 166 
ORA-06512: at line 10 
00907. 00000 -  "missing right parenthesis" 
*Cause:     
*Action: 

请您参考如下方法:

我不知道您的SP_AUDIT_TRAIL过程需要什么，但是我觉得您应该在字段列表中输入正确的引号:

in_fieldname_list := '''PROPTYPE'', ''ADDR1'', ''CITY'', ''STATE'', ''ZIP'', ''OAPPRAISAL''';