Qasim, what's up? How's the Triangle? I get it now. I didn't realize the connection was session independent.
I have noticed that i can let the link persist across sessions from my PL/SQL client...I didn't realize that was the case when I first wrote this question. But it has to be run FROM the cf server...hmmm. This would all be SOOO much easier if I were admin on that box. *sigh* Thanks! Dave P >As someone already indicated, why do you want to run db link command from >CF. It should be just a one time thing that your DBA can run. Later you can >run query against a table in linked database like this > >SELECT * >FROM > >On Wed, Aug 4, 2010 at 9:58 AM, W > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
