Re: calling a function over db link that creates a table in target db

From: George Rypysc <georgeryp+oracle_at_gmail.com>
Date: Mon, 30 Mar 2009 00:18:02 -0400
Message-ID: <op.urk7kcwinjbbs0_at_t2042>

On Sun, 29 Mar 2009 00:06:17 -0400, George Rypysc <georgeryp+oracle_at_gmail.com> wrote:

> Yes it is possible.
> What you tried first will work if you rewrite it using the older
> DBMS_SQL package instead of "EXECUTE IMMEDIATE".

I was wrong above (*if* you return a value). I tested it using DBMS_SQL and it gives the same error (ORA-02064) as your code.

I thought this was the same problem I had when trying to truncate a table over a db_link using EXECUTE IMMEDIATE but that was a different error: "ORA-02021: DDL operations are not allowed on a remote database"

I think Randolf is right.

-George Received on Sun Mar 29 2009 - 23:18:02 CDT