Re: calling a function over db link that creates a table in target db
From: <sybrandb_at_hccnet.nl>
Date: Fri, 27 Mar 2009 20:30:22 +0100
Message-ID: <k4aqs4ho28d4olidb6clj5ear2ofo1rb6g_at_4ax.com>
On Thu, 26 Mar 2009 05:29:53 -0700 (PDT), ciapecki <ciapecki_at_gmail.com> wrote:
Date: Fri, 27 Mar 2009 20:30:22 +0100
Message-ID: <k4aqs4ho28d4olidb6clj5ear2ofo1rb6g_at_4ax.com>
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
>(prepare_table_proc)?
>
>thanks,
>chris
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