## 报错信息：
Debug Start
Debug Initialize
Debug On
Debug Attach Session
Debug Synchronize And Continue
Run Procedure: "YYDI"."IMPORTDATA"
Procedure Failure: "YYDI"."IMPORTDATA"
ORA-00917: 缺失逗号
ORA-06512: 在 "YYDI.IMPORTDATA", line 65
ORA-06512: 在 line 1
Debug Off
Get Debug DBMS Output
Debug Complete
----------------
## 报错函数：
<p style="font-size:'12px';color:'blue';">CREATE OR REPLACE<br>
PROCEDURE IMPORTDATA<br>
AS<br>
v_sql VARCHAR2(2000);<br>
BEGIN<br>
v_sql := 'truncate table book_tempinfo';<br><br>
EXECUTE immediate v_sql;<br>
v_sql := 'insert into book_tempinfo<br>
(BOOKID,BOOKNAME,SERIESNAME,ISBN,WRITER,WRITERBRIEF,WRITEMETHOD,READERSHIP,<br>
RELATEDPRODUCT,BOOKCATEGORY,BOOKCATEGORY2,BOOKCATEGORY3,BOOKCATEGORY4,EDITOR,CIP,BOOKBRIEF,BARCODE,PROMOTIONWORD,
OTHERPRODUCT,DEPART,INSERTTIME,UPDATETIME,<br>
UPDATEFLAG,GETTIME,BOOKCATEGORY5,BNO,BOOKCATEGORY6,BOOKCATEGORY7,BOOKCATEGORY8,BOOKCATEGORY9,IMPORT_COPYRIGHT,KEYWORDS,<br>
SELLING_POINT,POPULARIZE_AREA,POPULARIZE_INDUSTRY,POPULARIZE_SCHOOL,IMPORTANTBOOK,BOOKCATEGORY10,CHR,BNOXT,CCL_FUSHEN,CCL_ZHONGSHEN,<br>
RKDATE,FXZS,ZSKSSJ,YC,JTCHB) <br>
select <br>
BOOKID,BOOKNAME,SERIESNAME,ISBN,WRITER,WRITERBRIEF,WRITEMETHOD,READERSHIP,<br>
RELATEDPRODUCT,BOOKCATEGORY,BOOKCATEGORY2,BOOKCATEGORY3,BOOKCATEGORY4,EDITOR,CIP,BOOKBRIEF,BARCODE,PROMOTIONWORD,<br>
OTHERPRODUCT,DEPART,INSERTTIME,UPDATETIME,<br>
UPDATEFLAG,GETTIME,BOOKCATEGORY5,BNO,BOOKCATEGORY6,BOOKCATEGORY7,BOOKCATEGORY8,BOOKCATEGORY9,IMPORT_COPYRIGHT,KEYWORDS,<br>
SELLING_POINT,POPULARIZE_AREA,POPULARIZE_INDUSTRY,POPULARIZE_SCHOOL,IMPORTANTBOOK,BOOKCATEGORY10,CHR,BNOXT,CCL_FUSHEN,CCL_ZHONGSHEN,<br>
RKDATE,FXZS,ZSKSSJ,YC,JTCHB <br>
from book_tempinfo@yydi';<br>
EXECUTE immediate v_sql ;<br>
v_sql := 'truncate table bookyc_tempinfo';<br>
EXECUTE immediate v_sql ;<br>
v_sql := 'insert into bookyc_tempinfo(BOOKID,<br>
BYC,<br>
WORDCOUNT,<br>
PAGENUMBER,<br>
FORMAT,<br>
BOOKSIZE,<br>
YINZHANG,<br>
PUBLISHDATE,<br>
to_timestamp(to_char(STORAGEDATE,"yyyy-mm-dd hh24:mi:ss"),"yyyy-mm-dd hh24:mi:ss"), <br>
INSERTTIME,<br>
UPDATETIME,<br>
UPDATEFLAG,<br>
GETTIME,<br>
BINDMODE,<br>
BOOKPRICE,<br>
FAPAIDATE,<br>
SCRAP_BOOK_MARKER<br>
) select BOOKID,<br>
BYC,<br>
WORDCOUNT,<br>
PAGENUMBER,<br>
FORMAT,<br>
BOOKSIZE,<br>
YINZHANG,<br>
PUBLISHDATE,<br>
STORAGEDATE,<br>
INSERTTIME,<br>
UPDATETIME,<br>
UPDATEFLAG,<br>
GETTIME,<br>
BINDMODE,<br>
BOOKPRICE,<br>
FAPAIDATE,<br>
SCRAP_BOOK_MARKER<br>
from bookyc_tempinfo@yydi';<br>
EXECUTE IMMEDIATE v_sql ;<br>
v_sql :='INSERT INTO S_LOG VALUES (SYSDATE)';<br><br>
EXECUTE IMMEDIATE v_sql;<br>
END IMPORTDATA;
</p>
是不是to_timestamp(to_char(STORAGEDATE,"yyyy-mm-dd hh24:mi:ss"),"yyyy-mm-dd hh24:mi:ss"), 双引号的问题
看下是不是中间那里一段的问题