Problem:
sqlcode=-208 Invalid object name for Sql*server 7 when doing an insert into local temporary table
Resolution:
The solution will be to create a local temporary table (#temptable) using Execute Immediate statement, then you will be able to do the insert. It's is a Microsoft problem for Sql*server 7 with ODBC drivers.
Old KB# 7069
