This content has been marked as final. Show 2 replies
You need to add a forward slash (/) after the procedure
create or replace procedure hr.hall_test is begin execute immediate 'TRUNCATE TABLE hr.hall_countries'; insert into hr.hall_countries (country_id,country_name,region_id) select country_id,country_name,region_id from hr.countries; commit; end; / begin . . .
Thanks this help me alot.