谢谢楼上的,不过,改了以后,还是有错误 ERROR at line 2: ORA-06550: line 2, column 9: PLS-00201: identifier 'DDMX4_ZDDM' must be declared ORA-06550: line 2, column 9: PL/SQL: Item ignored ORA-06550: line 3, column 7: PLS-00201: identifier 'DDMX4_DH' must be declared ORA-06550: line 3, column 7: PL/SQL: Item ignored ORA-06550: line 4, column 9: PLS-00201: identifier 'DDMX4_BDDH' must be declared ORA-06550: line 4, column 9: PL/SQL: Item ignored ORA-06550: line 17, column 22: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 17, column 6: PL/SQL: SQL Statement ignored ORA-06550: line 19, column 36: PLS-00201: identifier 'FSBMX' must be declared ORA-06550: line 19, column 6: PL/SQL: SQL Statement ignored 请大家帮帮继续看看
还有这么一个错误 ERROR at line 19: ORA-06550: line 19, column 36: PLS-00201: identifier 'FSBMX' must be declared ORA-06550: line 19, column 6: PL/SQL: SQL Statement ignored 我写的这个过程,是在ddmx4中取得zddm这个字段,然后,根据 fsbmx表中的fsbmx_zddm与zddm判断, 如果能取得数据,修改字段值。 在这个过程中,fsbmx这个表,需要如何声明?
ERROR at line 2:
ORA-06550: line 2, column 9:
PLS-00201: identifier 'DDMX4_ZDDM' must be declared
ORA-06550: line 2, column 9:
PL/SQL: Item ignored
ORA-06550: line 3, column 7:
PLS-00201: identifier 'DDMX4_DH' must be declared
ORA-06550: line 3, column 7:
PL/SQL: Item ignored
ORA-06550: line 4, column 9:
PLS-00201: identifier 'DDMX4_BDDH' must be declared
ORA-06550: line 4, column 9:
PL/SQL: Item ignored
ORA-06550: line 17, column 22:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 17, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 19, column 36:
PLS-00201: identifier 'FSBMX' must be declared
ORA-06550: line 19, column 6:
PL/SQL: SQL Statement ignored
请大家帮帮继续看看
ERROR at line 19:
ORA-06550: line 19, column 36:
PLS-00201: identifier 'FSBMX' must be declared
ORA-06550: line 19, column 6:
PL/SQL: SQL Statement ignored
我写的这个过程,是在ddmx4中取得zddm这个字段,然后,根据 fsbmx表中的fsbmx_zddm与zddm判断,
如果能取得数据,修改字段值。
在这个过程中,fsbmx这个表,需要如何声明?
zddm ddmx4.ddmx4_zddm%type;
dh ddmx4.ddmx4_dh%type;
bddh ddmx4.ddmx4_bddh%type;
dh ddmx4_dh%type;
bddh ddmx4_bddh%type;
定义的有问题
应该指向的是表中的字段zddm
ddmx4.ddmx4_zddm%type;
dh ddmx4.ddmx4_dh%type;
bddh ddmx4.ddmx4_bddh%type;
yxxx(小孬)他写的是对的