set sSql:=
concat(concat(concat(concat(concat(concat(concat(“insert into “,sTable_name),
“( Batch_id,         name,
EVENT_ID               ,CALL_TYPE           ,EVENT_TYPE_ID     ,
CALLING_AREA_CODE      ,CALLING_NBR         ,CALLED_AREA_CODE  ,
CALLED_NBR             ,START_DATE          ,DURATION          ,
SUM_AMOUNT             ,
SERV_ID                ,BILLING_AREA_CODE   ,BILLING_NBR       ,
BILLING_VISIT_AREA_CODE,ORG_CALLED_NBR      ,MSC               ,
LAC                    ,CELL_ID             ,CALLED_LAC        ,
CALLED_CELL_ID         ,OFFER_INSTANCE_ID1  ,OFFER_INSTANCE_ID2,
ACCT_ID1               ,ACCT_ID2
)
select
“)  ,iNewBatch_id),”name”),
iEvent_id )        ,”CALL_TYPE           ,EVENT_TYPE_ID     ,
CALLING_AREA_CODE      ,CALLING_NBR         ,CALLED_AREA_CODE  ,
CALLED_NBR             ,START_DATE          ,DURATION          ,
SUM_AMOUNT             ,
SERV_ID                ,BILLING_AREA_CODE   ,BILLING_NBR       ,
BILLING_VISIT_AREA_CODE,ORG_CALLED_NBR      ,MSC               ,
LAC                    ,CELL_ID             ,CALLED_LAC        ,
CALLED_CELL_ID         ,OFFER_INSTANCE_ID1  ,OFFER_INSTANCE_ID2,
ACCT_ID1               ,ACCT_ID2
from parse_billing
where event_id = “),iInEvent_id);
—
报错信息不会复制截图。
意思就是在select 语句哪里又语法错误。求帮助一下。