更新时间:2023-01-21 10:56:57
对于这个陈述,我只是忘了使用绑定变量,例如:
For this statement I'd just forget about using a bind variable, e.g.:
declare
l_trc_cmd varchar2(500);
l_sql_id varchar2(500) := 'asasasaass';
begin
l_trc_cmd := REPLACE(
q'# alter session set events 'sql_trace [sql: %SQLID%]' #'
,'%SQLID%',l_sql_id);
execute immediate l_trc_cmd;
end;
/