Re: Querying multiple Oracle datasources - separate logins - 1 cfquer y

You could do a database link to accomplish this as well. Your oracle DBA would have to set this up, but you can actually query tables on a completely different server, given the appropriate grants. (We did this while transitioning from 8.1.5 to 8.1.7.) -Deanna Deanna Schneider Interactive Medi

Re: Querying multiple Oracle datasources - separate logins - 1 cfquer y

-- Original Message -- From: "Carlisle, Eric" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 5 Jun 2002 10:03:22 -0400 >Is it possible to join tables in 2 different Oracle datasources (using 2 >different logins)? > >This is a loaded question b

Re: Querying multiple Oracle datasources - separate logins - 1 cfquer y

oi Eric!! you might wanna swing into #coldfusion on efnet..some bloke was in there this morning talking bout roughly the same thing. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - Wednesday, June 5, 2002, 10:03:22 AM, you wrote: CE> Is

Querying multiple Oracle datasources - separate logins - 1 cfquer y

Is it possible to join tables in 2 different Oracle datasources (using 2 different logins)? This is a loaded question because I know you can't. You probably need to use a stored procedure or a view. I can do 2 seperate queries, but since both tables are required to narrow down the results, the