Oracle触发器中的动态查询出错

2023-04-02 admin

我正在尝试创建一个查询，以便在触发器中将表的新数据转换为xml

create or replace TRIGGER EVAL_CHANGE_TriggerActual_Test
  AFTER INSERT OR UPDATE OR DELETE
  ON PROJ_TEST
  REFERENCING NEW AS new OLD AS old
 FOR EACH ROW
DECLARE
 p_xmldata     XMLtype;
  P_NEWROWDATA    clob;
  p_newrowxml       clob;  
BEGIN

p_newrowxml:='select XMLElement("ResearchTable",XMLElement("DESCR", :NEW.DESCR)) from dual';
EXECUTE IMMEDIATE  p_newrowxml  into p_xmldata   ; //Error here 
 p_newrowdata:=p_xmldata.getClobVal();  
END;

如果我把NEW.DESCR去掉一些静态的，它会工作的

注意:我需要将查询保持为字符串，因为稍后它将由一些SP生成

转载请注明出处:http://www.sjzxcyzs.com/article/20230402/1819493.html