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

From: <>
Date: Fri, 27 Mar 2009 20:30:22 +0100
Message-ID: <>

On Thu, 26 Mar 2009 05:29:53 -0700 (PDT), ciapecki <> 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

Original text of this message