create or replace procedure testir --( --memberugaid IN number, --groupugaid IN number --) AS v_test varchar(2000); v_test_long long; v_test_longid long; v_status number; BEGIN delete from rodmess; commit; --insert_relation(memberugaid,groupugaid,1); --insert_member(memberugaid,memberugaid); --cnav_keyvalues_from_rowid(v_test,'DEPARTMENT','000051F3.0002.0005'); cnav_remove_relation(v_status,1028076,213401); --insert into rodmess values(v_test_long); --commit; --insert into rodmess values(v_test_longid); --commit; END testir; / show errors;