oracle 过程执行中途报错?什么原因
求解,急啊
------解决方案--------------------请贴出错误信息或你的存储过程的代码
要不然,神知道是什么错误啊,呵呵。
------解决方案--------------------过程是这样的
PROCEDURE INTEGRAL_FOR_TELE(I_ID IN NUMBER) IS
CURSOR CUR1 IS
SELECT
A.S_ID SID,
B.C_NAME CNAME,
A.A_NBR ANBR,
A.A_ID AID,
B.MANAGER MANAGER,
B.C_C_ID CCID,
T.X_BASE_POINT TELEINTEGRAL,
SYSDATE CREATEDT
FROM CUSTOM.STAR A,CUSTOM.CUST B,S_LOY_MEMBER T
WHERE B.C_ID = A.C_ID
AND T.MEM_NUM = B.C_C_ID
AND A.STATE = 'A'
AND B.STATE = 1
AND B.ID = I_ID
AND A.ID = I_ID;
BEGIN
EXECUTE IMMEDIATE 'DELETE FROM CUSTOM.INTEGRAL_WARNING WHERE ID ='