Hi I want to store a avalue of select statement into a variable and then update my table using that variable within the procedure but there is an error . I still dont know its only returning one column then also below error exists.
**exact fetch returns more than requested number of rows.**

Here is the example of demo code.Can anyone please give me an alternative of what else I can do here to make it work since I have many such plsql statement to populate table columns

```
create or replace procedure pcountry (country IN Varchar) is
var_date Date;
begin

select date into var_date from countrytable where country=country;

update newtable
set date=var_date
where country=country
commit;

end pcountry;

```