报错信息:
Procedure execution failed
ORA-00917: 缺失逗号
ORA-06512: 在 "YYDI.IMPORTDATA", line 64
ORA-06512: 在 line 1
查询时间: 30.073s
报错函数:
CREATE OR REPLACE
PROCEDURE IMPORTDATA
AS
v_sql VARCHAR2(2000);
BEGIN
v_sql := 'truncate table book_tempinfo';
EXECUTE immediate v_sql;
v_sql := 'insert into book_tempinfo
(BOOKID,BOOKNAME,SERIESNAME,ISBN,WRITER,WRITERBRIEF,WRITEMETHOD,READERSHIP,
RELATEDPRODUCT,BOOKCATEGORY,BOOKCATEGORY2,BOOKCATEGORY3,BOOKCATEGORY4,EDITOR,CIP,BOOKBRIEF,BARCODE,PROMOTIONWORD,
OTHERPRODUCT,DEPART,INSERTTIME,UPDATETIME,
UPDATEFLAG,GETTIME,BOOKCATEGORY5,BNO,BOOKCATEGORY6,BOOKCATEGORY7,BOOKCATEGORY8,BOOKCATEGORY9,IMPORT_COPYRIGHT,KEYWORDS,
SELLING_POINT,POPULARIZE_AREA,POPULARIZE_INDUSTRY,POPULARIZE_SCHOOL,IMPORTANTBOOK,BOOKCATEGORY10,CHR,BNOXT,CCL_FUSHEN,CCL_ZHONGSHEN,
RKDATE,FXZS,ZSKSSJ,YC,JTCHB)
select
BOOKID,BOOKNAME,SERIESNAME,ISBN,WRITER,WRITERBRIEF,WRITEMETHOD,READERSHIP,
RELATEDPRODUCT,BOOKCATEGORY,BOOKCATEGORY2,BOOKCATEGORY3,BOOKCATEGORY4,EDITOR,CIP,BOOKBRIEF,BARCODE,PROMOTIONWORD,
OTHERPRODUCT,DEPART,INSERTTIME,UPDATETIME,
UPDATEFLAG,GETTIME,BOOKCATEGORY5,BNO,BOOKCATEGORY6,BOOKCATEGORY7,BOOKCATEGORY8,BOOKCATEGORY9,IMPORT_COPYRIGHT,KEYWORDS,
SELLING_POINT,POPULARIZE_AREA,POPULARIZE_INDUSTRY,POPULARIZE_SCHOOL,IMPORTANTBOOK,BOOKCATEGORY10,CHR,BNOXT,CCL_FUSHEN,CCL_ZHONGSHEN,
RKDATE,FXZS,ZSKSSJ,YC,JTCHB
from book_tempinfo@yydi';
EXECUTE immediate v_sql ;
v_sql := 'truncate table bookyc_tempinfo';
EXECUTE immediate v_sql ;
v_sql := 'insert into bookyc_tempinfo(BOOKID,
BYC,
WORDCOUNT,
PAGENUMBER,
FORMAT,
BOOKSIZE,
YINZHANG,
PUBLISHDATE,
to_timestamp(to_char(STORAGEDATE,"yyyy-mm-dd hh24:mi:ss"),"yyyy-mm-dd hh24:mi:ss"),
INSERTTIME,
UPDATETIME,
UPDATEFLAG,
GETTIME,
BINDMODE,
BOOKPRICE,
FAPAIDATE,
SCRAP_BOOK_MARKER
) select BOOKID,
BYC,
WORDCOUNT,
PAGENUMBER,
FORMAT,
BOOKSIZE,
YINZHANG,
PUBLISHDATE,
STORAGEDATE,
INSERTTIME,
UPDATETIME,
UPDATEFLAG,
GETTIME,
BINDMODE,
BOOKPRICE,
FAPAIDATE,
SCRAP_BOOK_MARKER
from bookyc_tempinfo@yydi';
EXECUTE IMMEDIATE v_sql ;
v_sql :='INSERT INTO S_LOG VALUES (SYSDATE)';
EXECUTE IMMEDIATE v_sql;
END IMPORTDATA;