CREATE DB-LINK with native dynamic SQL

[Quoted] [Quoted] it is possible to create a db link with sql*plus. But the same statement in native dynamic sql used in a stored procedure returns with an error. Why ?

[Quoted] The alternative I use now is, create the db link, then run the procedure, then
drop the db link in a sql*plus-script. But this version can be running a little bit instabil. ( e.g. "rollback segment too small", etc )

Is there anyone who knows a better way ?

With thanks and kind regards

Christian Antonin Received on Thu Jan 10 2002 - 14:59:10 CET