我正在尝试立即执行整个FOR循环,但它不起作用。这是有可能的吗? FOR V_ROW IN (SELECT ROWNUM AS RN,ID AS ID FROM (SELECT ID FROM T_OPDM_PLANDEACCION WHERE IDOPORTUNIDAD=2 ORDER BY ORDEN)) LOOP UPDATE T_OPDM_PLANDEACCION SET ORDEN=V_ROW.RN WHERE ID=V_ROW.ID;END LOOP;
EXECUTE IMMEDIATE 'FOR V_ROW IN (SELECT ROWNU
我正在为no_data_found使用用户定义的异常,但仍然看到ORA-06512堆栈信息以及用户定义的异常ORA-20106。ORA-20106: Problem in loading Affected Circle data
ORA-06512: at "SRUSER.ADD_AFFECTEDCIRCLE", line 30如何抑制ORA-06512堆栈信息?
ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at
在 SQL 开发人员上执行 tax_calc_sf 函数时,我不断收到以下错误。. enter image description here我也不确定为什么它总是在进程退出后立即与数据库断开连接。对此的任何帮助将不胜感激。 CREATE OR REPLACE FUNCTION tax_calc2_sf p_sub NUMBER) IS BEGIN INTO lv_tax_num
FROM bb_basket b,