oracle，存储过程问题，大侠们看看！

Question

PLS-00485：在异常处理程序中，‘true’ 必须有一个错误名

Answer 1

CREATE OR REPLACE PROCEDURE PRO_qgzt_sjtb IS
TYPE CURTYPE IS REF CURSOR;
C_CR CURTYPE;
V_RYID ZHSJ_QGZTRY.RYID%TYPE;--------------- 就是报这行错误
V_RYBH ZHSJ_QGZTRY.RYBH%TYPE;
V_JRYBH ZHSJ_QGZTRY.JRYBH%TYPE;
V_XM ZHSJ_QGZTRY.XM%TYPE;
V_XB_DM ZHSJ_QGZTRY.XB_DM%TYPE;
V_CSRQ_SX ZHSJ_QGZTRY.CSRQ_SX%TYPE;
V_CSRQ_XX ZHSJ_QGZTRY.CSRQ_XX%TYPE;
V_SFZH ZHSJ_QGZTRY.SFZH%TYPE;
V_MZ_DM ZHSJ_QGZTRY.MZ_DM%TYPE;
V_SG ZHSJ_QGZTRY.SG%TYPE;
V_KY_DM ZHSJ_QGZTRY.KY_DM%TYPE;
V_ZY_DM ZHSJ_QGZTRY.ZY_DM%TYPE;
V_HJD_QH ZHSJ_QGZTRY.HJD_QH%TYPE;
V_HJD_XZ ZHSJ_QGZTRY.HJD_XZ%TYPE;
V_XZD_QH ZHSJ_QGZTRY.XZD_QH%TYPE;
V_XZD_XZ ZHSJ_QGZTRY.XZD_XZ%TYPE;
V_JG_QH ZHSJ_QGZTRY.JG_QH%TYPE;
V_JG_XZ ZHSJ_QGZTRY.JG_XZ%TYPE;
V_ZWBH ZHSJ_QGZTRY.ZWBH%TYPE;
V_DNA ZHSJ_QGZTRY.DNA%TYPE;
V_RYFJXX ZHSJ_QGZTRY.RYFJXX%TYPE;
V_AJBH ZHSJ_QGZTRY.AJBH%TYPE;
V_AJLB_DM ZHSJ_QGZTRY.AJLB_DM%TYPE;
V_ZTLX_DM ZHSJ_QGZTRY.ZTLX_DM%TYPE;
V_JJ ZHSJ_QGZTRY.JJ%TYPE;
V_JYAQ ZHSJ_QGZTRY.JYAQ%TYPE;
V_TPRQ ZHSJ_QGZTRY.TPRQ%TYPE;
V_TPFX_QH ZHSJ_QGZTRY.TPFX_QH%TYPE;
V_LASJ ZHSJ_QGZTRY.LASJ%TYPE;
V_LA_DWQH ZHSJ_QGZTRY.LA_DWQH%TYPE;
V_LA_DWDM ZHSJ_QGZTRY.LA_DWDM%TYPE;
V_LA_DWXC ZHSJ_QGZTRY.LA_DWXC%TYPE;
V_LA_DWXT_DM ZHSJ_QGZTRY.LA_DWXT_DM%TYPE;
V_ZB_DWQH ZHSJ_QGZTRY.ZB_DWQH%TYPE;
V_ZB_DWDM ZHSJ_QGZTRY.ZB_DWDM%TYPE;
V_ZB_DWXC ZHSJ_QGZTRY.ZB_DWXC%TYPE;
V_ZB_LXR ZHSJ_QGZTRY.ZB_LXR%TYPE;
V_ZB_LXFS ZHSJ_QGZTRY.ZB_LXFS%TYPE;
V_DJ_TBR ZHSJ_QGZTRY.DJ_TBR%TYPE;
V_DJ_RQ ZHSJ_QGZTRY.DJ_RQ%TYPE;
V_DJ_SPR ZHSJ_QGZTRY.DJ_SPR%TYPE;
V_DBJB_DM ZHSJ_QGZTRY.DBJB_DM%TYPE;
V_TJLBH ZHSJ_QGZTRY.TJLBH%TYPE;
V_BLYY ZHSJ_QGZTRY.BLYY%TYPE;
V_BLBS ZHSJ_QGZTRY.BLBS%TYPE;
V_SP ZHSJ_QGZTRY.SP%TYPE;
V_SPYY ZHSJ_QGZTRY.SPYY%TYPE;
V_LR_DWDM ZHSJ_QGZTRY.LR_DWDM%TYPE;
V_LRR ZHSJ_QGZTRY.LRR%TYPE;
V_LRSJ ZHSJ_QGZTRY.LRSJ%TYPE;
V_XG_DWDM ZHSJ_QGZTRY.XG_DWDM%TYPE;
V_XGR ZHSJ_QGZTRY.XGR%TYPE;
V_XGSJ ZHSJ_QGZTRY.XGSJ%TYPE;
V_SC_DWDM ZHSJ_QGZTRY.SC_DWDM%TYPE;
V_SCR ZHSJ_QGZTRY.SCR%TYPE;
V_SCSJ ZHSJ_QGZTRY.SCSJ%TYPE;
V_SC_DWXC ZHSJ_QGZTRY.SC_DWXC%TYPE;
V_SC_DWXT_DM ZHSJ_QGZTRY.SC_DWXT_DM%TYPE;
V_SC_SPR ZHSJ_QGZTRY.SC_SPR%TYPE;
V_ZKBZ ZHSJ_QGZTRY.ZKBZ%TYPE;
V_RBKSJ_DJ ZHSJ_QGZTRY.RBKSJ_DJ%TYPE;
V_RBKSJ_CX ZHSJ_QGZTRY.RBKSJ_CX%TYPE;
V_RBKSJ_SC ZHSJ_QGZTRY.RBKSJ_SC%TYPE;
V_SY_DWDM ZHSJ_QGZTRY.SY_DWDM%TYPE;
V_SBSJ ZHSJ_QGZTRY.SBSJ%TYPE;
V_SQL        VARCHAR2(1500);---------------------这是前面一点

Answer 2

V_RYID ZHSJ_QGZTRY.RYID%TYPE;--------------- 就是报这行错误在表名 跟字段没有问题的前提下 是没有问题的估计不是这的问题 全部的代码