Urgent HELP !! Cant insert a record to other table !

[skid]

The select statement returns more than one row. Try doing a Cursor For loop so that you can insert all the records return by the sql statment.

ex.

for rec in (select * from tenants)
loop
--
-- your insert statement here.
--
end loop;