Re: aliases and links

Mark,

Try writing a stored procedure which uses dynamic SQL feature to issue appropriate DDL statements (CREATE DATABASE LINK....)

I am not sure if you would be able to invoke the procedure from the INSERT trigger; if not, is it possible for you to change INSERT statement to a procedure call? The procedure would take care of inserting the record and creating the link then.

BTW, what is an alias for a database?

SY
Anton

Mark G. Woodruff wrote in message <6ishfc$lnt$1_at_comet2.magicnet.net>...
>I have a table containing a list of databases. When someone adds a record
 to
>the table (via SQL INSERT through JDBC), I'd like to automatically add an
>appropriate link and alias for that database using Oracle 7.3.4.
>
>Any suggestions on how to do it?
>
>
Received on Fri May 08 1998 - 00:00:00 CDT