有大佬知道哪里出错了吗
BEGIN
CREATE TEMPORARY TABLE IF NOT EXISTS jszxseal
( apv_code VARCHAR(255) ,
apv_title VARCHAR(255) ,
create_name varchar(255) ,
create_depart varchar(255) ,
update_time date DEFAULT NULL,
apv_user_name VARCHAR(255) ,
title VARCHAR(255)
);
BEGIN
insert into jszxseal(apv_code,apv_title,create_name,create_depart,update_time,apv_user_name,title)
SELECT a.apvCode AS apv_code,a.apvTitle AS apv_title,a.createName AS create_name,a.createDpart AS create_depart,a.updateTime AS update_time,a.apvUserName AS apv_user_name,b.title AS title
FROM (SELECT a.id AS id,a.apv_code AS apvCode,a.apv_title AS apvTitle,a.create_name AS createName,a.create_dpart AS createDpart,a.update_time AS updateTime,b.apv_user_name AS apvUserName FROM (SELECT id,apv_code,apv_title,create_name,create_dpart,DATE_FORMAT(update_time,'%Y-%m-%d') AS update_time FROM oa_apv_main WHERE apv_code LIKE 'GCYY%' AND apv_status=3 ) a
LEFT JOIN (SELECT GROUP_CONCAT(apv_user_name ORDER BY step_num ASC SEPARATOR '->') AS apv_user_name,apv_code FROM oa_apv_step where apv_code LIKE 'GCYY%' GROUP BY apv_code) b
ON a.apv_code=b.apv_code ORDER BY apvCode ASC) a LEFT JOIN (SELECT a.apv_main_id AS mainId , b.title AS title FROM (SELECT * FROM oa_apv_form_seal WHERE seal_name IN ('1465164880667316225','1465165166689488897','1465165488786870273','1465165849870307329','1465166105517330433','1465166318520864769','1465166545080389634','1465166861439963137','1465167073688522753','1465852427647156225','1498938936889450497') ) a LEFT JOIN (SELECT * FROM oa_apv_flow_clause WHERE dep_id LIKE '402880e447e9a9570147e9b677320003' AND title LIKE '%章%' ) b ON b.id=a.seal_name) b ON a.id=b.mainId;
SELECT * FROM jszxseal;
end;
truncate TABLE jszxseal;
END
CREATE TABLE这种是DDL语句,达梦不支持在存储过程或函数中直接写DDL,可以使用execute immediate+动态sql的方式