dbms_smtp and db links

[Kenrae]

Hello all,

I have a problem using this package through a db link. I'm calling a package done by me which uses dbms_smtp. This package works fine when I execute it as the owner. But when I try to execute it through a db link from another user, I receive this error:

ORA-02064: distributed operation not supported
ORA-06512: at "TOOLS.UTIL", line 80
ORA-02064: distributed operation not supported
ORA-06512: at line 4

I don't know how to handle it. It worked fine last week.
The db link works fine.
What can it be?

 

[karluk]

Are you saying that the remote procedure call worked last week? If so, have you modified your package?

According to the documentation, ORA-02064 is generated because of certain limitations in executing remote procedure calls. That's basically your situation, so it's possible that you may simply not be able to call your package through a db link.

What is the specific sql that is executing when you get the error? Maybe you can rewrite to avoid the error.

 

[Kenrae]

Yes, my rpc worked last week. And what's more, it works on another machine! (through a db link, too).
In my SQL I only execute the procedure, nothing more.