ora-01008: not all variables bound error with database link

[moepower]

My stored procedure is as follows:

l_unix_date number(38);

begin
l_unix_date := time_converter.unix(sysdate);

insert into table_a
(col1, col2)
select a.val1, a.val2, b.val3, b.val4
from table_b@dblink1 a, table_c@dblink2 b
where a.col1 = l_unix_date
and a.col2 = b.col2;

exception
.
.
end;

Oracle is complaining my use of l_unix_date. I know there is a bug report with Oracle on this, but is there another way for me to do this? I don't want to have to put the unix time conversion package into the where clause.

Thanks,