急！ ORACLE8I下存储过程错误，在线等待，完成马上结帖！！！

Question

CREATE OR REPLACE PROCEDURE chock_mount_bearing_procedure 
( new_chock_id       IN   VARCHAR2(7),
  new_plain_bear_id  IN   VARCHAR2(7),
  new_axial_bear_id  IN   VARCHAR2(7))ASBEGIN     UPDATE   res_chock
     SET      plain_bear_id = new_plain_bear_id,  
              axial_bear_id = new_axial_bear_id,
              state         = 30
     WHERE    chock_id      = new_chock_id;END chock_mount_bearing_procedure;

Answer 1

new_chock_id       IN   VARCHAR2,
  new_plain_bear_id  IN   VARCHAR2,
  new_axial_bear_id  IN   VARCHAR2参数不能定义长度

Answer 2

To:  jiezhi(西域浪子) 
To:   bzszp(SongZip) 
大侠：还是提示错误，
警告：创建的过程带有编译错误。

Answer 3

CREATE OR REPLACE PROCEDURE chock_mount_bearing_procedure 
( new_chock_id       IN   VARCHAR2,
  new_plain_bear_id  IN   VARCHAR2,
  new_axial_bear_id  IN   VARCHAR2)ASBEGIN     UPDATE   res_chock
     SET      plain_bear_id = '||new_plain_bear_id||',  
              axial_bear_id = '||new_axial_bear_id}}',
              state         = 30
     WHERE    chock_id      = '||new_chock_id||';END chock_mount_bearing_procedure;

Answer 4

sorry,}}->||
CREATE OR REPLACE PROCEDURE chock_mount_bearing_procedure 
( new_chock_id       IN   VARCHAR2,
  new_plain_bear_id  IN   VARCHAR2,
  new_axial_bear_id  IN   VARCHAR2)ASBEGIN     UPDATE   res_chock
     SET      plain_bear_id = '||new_plain_bear_id||',  
              axial_bear_id = '||new_axial_bear_id||',
              state         = 30
     WHERE    chock_id      = '||new_chock_id||';END chock_mount_bearing_procedure;

Answer 5

CREATE OR REPLACE PROCEDURE chock_mount_bearing_procedure 
( new_chock_id       IN   VARCHAR2,
  new_plain_bear_id  IN   VARCHAR2,
  new_axial_bear_id  IN   VARCHAR2)ASBEGIN     UPDATE   res_chock
     SET      plain_bear_id = new_plain_bear_id,  
              axial_bear_id = new_axial_bear_id,
              state         = 30
     WHERE    chock_id      = new_chock_id;END chock_mount_bearing_procedure;
/SHOW ERROR;

Answer 6

To: NiuNiuTZ(独立小桥风满袖)
小弟比较菜，没看懂以下PL/SQL过程，能不能详细说以下UPDATE   res_chock
     SET      plain_bear_id = '||new_plain_bear_id||',  
              axial_bear_id = '||new_axial_bear_id}}',
              state         = 30
     WHERE    chock_id      = '||new_chock_id||';