Can't you just get the DBA to create the dblink?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 6 August 2010 03:23, Dave P wrote:
>
> Qasim, what's up? How's the Triangle?
>
> I get it now. I didn't realize the connection was session independent.
>
> I have noticed
We do this all the time with one of our government clients.
Unfortunately I have no good idea as to how it was setup (their DBAs
handle that part).
What I can say is
1) When we have cross-schema joins it is done using proper FKs setup
between the schemas
2) permissions involve SELECT and R
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
Won,
Yes, schema to schema.
I'm attempting a join across databases. These databases used to be on the same
server with different owners.
They just moved our app to another server, and now I have to use a DB link to
get the same join to work.
The outcome of these queries is an internal rep
My last email was incomplete
SELECT *
FROMyourtableinlinke...@nameofdblink
On Wed, Aug 4, 2010 at 8:25 PM, Qasim Rasheed wrote:
> 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 qu
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, Won Lee wrote:
>
> I assume you mean a link
I assume you mean a link from one oracle schema to another schema by
executing the CREATE DATABASE LINK sql command through a CFML page.
Is this correct? If it is check your permissions. This most likely has
nothing to do with CF. As I side note, I don't think CFML pages should be
running this
-
From: Dave P [mailto:jda...@gmail.com]
Sent: Wednesday, August 04, 2010 8:12 AM
To: cf-talk
Subject: oracle database link
Hello all,
Has anyone actually gotten a database link working from a CF server to a
second oracle server?
I'm trying a connection string:
create database link pro
Hello all,
Has anyone actually gotten a database link working from a CF server to a second
oracle server?
I'm trying a connection string:
create database link prodlink connect to identified by
using 'PROD';
and getting:
Error Executing Database Query.
Executing the SQL statement is not al
9 matches
Mail list logo