为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server x64 V7.1.5.95-Build(2016.06.28-70305)ENT
【操作系统】:凝思
【CPU】:
【问题描述】*:调用存储过程有问题,报字符串截断
exec data_statics202307 20230730,0,NULL
创建存储过程的代码
/create or replace procedure data_statics202307
(static_intsdate int default 0,
correct_flag int default 0,
static_object varchar2 default NULL)
as
rel_date int;
begin
day_statics202307a (static_intsdate,static_object);
pday_statics202307a (static_intsdate,static_object);
mon_statics202307a (static_intsdate,static_object);
pmon_statics202307a (static_intsdate,static_object);
year_statics202307a (static_object);
pyear_statics202307a (static_object);
table_maintenance();
commit;
end;/
经过调试,发现是这一句出现字符串截断sql_creat_table :=CONCAT('CREATE global TEMPORARY table ',table_name_str,'(NAME varchar2(512)),SDATE NUMBER(512),TIME NUMBER(512),FLAG NUMBER(512),DATA REAL(512),ODATE NUMBER(512),OTIME NUMBER(512),OFLAG NUMBER(512)) on COMMIT PRESERVE ROWS');