Re: calling a function over db link that creates a table in target db
Date: Fri, 27 Mar 2009 20:30:22 +0100
On Thu, 26 Mar 2009 05:29:53 -0700 (PDT), ciapecki <ciapecki_at_gmail.com> wrote:
>Is it possible to achieve the goal without that wrapper procedure
Apart from the fact creating tables on the fly in pl/sql is just plain
evil, you could have gathered from the error message (which you
obviously didn't check in the online documentation), Oracle *doesn't
support distributed DDL*!!!!
So the answer is there are probably several ways to get you out of the on-the-fly table creation mess, or get you furthe in it, but dumping what you call the 'wrapper procedure' (IMO it is just a nightmare), is not one of them.
--Received on Fri Mar 27 2009 - 14:30:22 CDT