Distincts Databases On The Same Stored Procedure

Hi!

    I need to use two distincts databases on the same stored procedure. One, database1, is where I want to place the procedure, and where the table the procedure populates is (table1). The other, database2, hosts the table (table2) from where I select some data to put into table1 in database1.
    Database1 name is fixed, while database2 name may change. So, I would like to pass database2 name as a parameter to the procedure. In this simple example, it works fine:

use database1
go
create procedure teste @db_name varchar(10) as
exec ('select * from ' + @db_name + '.dbo.table2')

    But the problem is that in my procedure, database2 is used in a cursor, something like this:

create procedure myProcedure @year int, @pDatabase2 varchar(30) AS

declare ...

WHILE ...
BEGIN
  ... 
  declare cursor1 cursor for 
 select column1, column2 from @pDatabase2.dbo.table2
 where ...

  open cursor1
 fetch next from cursor1 into ...

  close cursor1
  deallocate cursor1
   
 -- insert data into table
 INSERT INTO table1
     VALUES...

....

    And I get an error if I try to use the exec! How can I do it? Can anyone help me please?

         Thank you!