运行PLSQL Developer 执行procedure的时候
create or replace procedure sem_108_inser
(
v_id in sem_108.V_ID %type,
v_name in sem_108.V_NAME%type
)
as
str_sql varchar2(500);
begin
str_sql:='insert into sem_108_inser values(:v_id,:v_name)';
execute immediate str_sql using v_id,v_name;
if SQL%found then
dbms_output.put_line('inserted OK!');
end if;
end sem_108_inser;
进入test该procedure的时候,调式工具运行到execute immediate str_sql using v_id,v_name;
这条语句的时候,调式窗口就没有了反应
create or replace procedure sem_108_inser
(
v_id in sem_108.V_ID %type,
v_name in sem_108.V_NAME%type
)
as
str_sql varchar2(500);
begin
str_sql:='insert into sem_108_inser values(:v_id,:v_name)';
execute immediate str_sql using v_id,v_name;
if SQL%found then
dbms_output.put_line('inserted OK!');
end if;
end sem_108_inser;
进入test该procedure的时候,调式工具运行到execute immediate str_sql using v_id,v_name;
这条语句的时候,调式窗口就没有了反应
execute immediate str_sql using v_id,v_name;
应该先把sql拼写好,
然后
execute immediate (str_sql);