Re: Create database link from inside a stored procedure

Jeremy wrote:

> It is to do with a kind of "meta data" that may be assembled in a test
> environment and that we then want to be able to deploy to another
> database using PL/SQL and a web interface. As the target database may
> not be known at the time of compile (it won't be), we will use dynamic
> SQL to create the database link and to then copy the relevant rows to
> the target database.
>
> I am assuming you will now find all sorts of reasons why this simply
> should not be done this way. I'm listening .... ;)

As long as you said "test environment" I have no reason why you shouldn't engage in this activity. Had you said production, however, I'd likely have a few. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)