I want to execute multiple update statements in single non-query without using proc.
update table_name set endo_code=null,issue_date=null,update_time=sysdate,status_id=150,next_endo_id =s_gedo_endorsement__endo_id.nextval where endo_id in (endoid);
update table_name set Lock_Flag=0 where OTHER_ref_id in (endoid);
Call package(endoid);