Did you get an anwer?

I have same issue.

e think it could be Oracle HS (heterogeneous services) Gateway configuration problem.

I can do the insert from a trigger from sql server 2005 to sql server 2005, but not from sql server to Oracle 10g.