oracle - pls 00905 object is invalid -
create or replace procedure p_update_project_status(v_project_id in number(10)) declare v_bid_file_status number(2); v_bid_form_status number(2); v_supplier_status number(2); begin select status v_bid_file_status project_file type = 0 , associated_project_id = v_project_id; select status v_bid_form_status project_file type = 1 , associated_project_id = v_project_id; select status v_supplier_status supplier_info associated_project_id = v_project_id; if( (v_bid_file_status = 3) , (v_bid_form_status = 3) , (v_supplier_status = 3) ) update project_info set status = 3 id = v_project_id; else update project_info set status = 0 id = v_project_id; end if; end;
i execute procedure,but it's invalid, have tried best correct it, still invalid.i don't know going wrong.please me
declare keyword not necessary here. need if youre running anonymous block. remove , should compile.
Comments
Post a Comment