建立一个过程如下,使用动态sql更新表,为什么一直报错说"ss": 标识符无效?!!!!!!!!! 难道动态Sql里不能使用变量吗??
create or replace procedure proc_a
(
table_name in varchar2,
) as
str_sql varchar2(500);
ss number;
begin
select a into ss from table;
str_sql:='update '||table_name||' set fint_volume=fint_lv* ss';
execute immediate str_sql;
commit;
end ;
create or replace procedure proc_a
(
table_name in varchar2,
) as
str_sql varchar2(500);
ss number;
begin
select a into ss from table;
str_sql:='update '||table_name||' set fint_volume=fint_lv* ss';
execute immediate str_sql;
commit;
end ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货