存储过程

1.  update 'long raw ' 字段，超过2000个字符

create or replace procedure pro_updatelr AUTHID CURRENT_USER isn varchar2(8000);m long raw;beginn :=rpad('f',8000,'f');m :=utl_raw.cast_to_raw(n);update oss_trans1 set col_2=m where col_0=8637370;commit;end pro_updatelr;/call pro_updatelr();