sql - Procedure created with compilation errors - but can't find error -
i have procedure can't find error is:
create or replace procedure add_grade ( studen_id in varchar2(6), sec_id in number(6), new_grade in char (1) ) begin update enrollment set grade = new_grade s_id = studen_id , c_sec_id = sec_id; end; /
run query ..
select * user_errors name ='add_grade'
and youll have error
Comments
Post a Comment