Re: Create database link from inside a stored procedure

Mark D Powell wrote:
> You know I am not sure I really see an issue with this specific
> example. I do not believe in allowing tables or indexes to be created
> on the fly, but this problem is we want to insert data to a remote
> database and we do not know the database information until we get a
> request.

I do on many fronts. Just two of which are:

1. Thinking Sarbanes Oxley or Basell II or other similar laws there are issues of security and auditing.
2. Who is making the entries in the TNSNAMES.ORA file? The end user? Or is every database in the entire enterprise going to be in the TNSNAMES and who is going to maintain it? -- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)