RE: [sqr-users] Embedding Database Link in SQR

[Bob Stone <bstone@fastenal.com>]

Mary,

Do you need to recreate the link each time?  You should be able to create
one link, once, then use it each time.  If there's a link between the DBs
you should be able to use it without recreating it.  

Or, if the link might have different properties each time, such that you
need to recreate it, consider putting the 'drop db link' 'create db link'
logic in a stored procedure on the database itself.  

Thanks
bob stone  - inventory developer  x8514

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
davismm@oneonta.edu
Sent: Monday, October 25, 2004 8:00 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Embedding Database Link in SQR


Hi, All!
 
I'm attempting to embed a database link within an SQR.  The code I'm
using is
 
 
BEGIN-SQL
        CREATE PUBLIC DATABASE LINK database_name
        CONNECT TO SYSTEM IDENTIFIED AS password
        USING 'database_name.WORLD';
END-SQL
 
If I do this before running the SQR, things work fine.  However, if I
just run the SQR,
I get ORA-02019 errors: 'Connection description for remoter database not
found.'
 
We're at Oracle 9.2.0.4, SQR version 4.3.4 (SQRIBE).
 
Thanks in advance.
 
Mary
 
*****************************************************************
Mary M. Davis
SICAS Center  Lee Hall
State University of New York
Oneonta, NY 13820
 
davismm@oneonta.edu <mailto:davismm@oneonta.edu> 
 
Phone:  (607) 436-2031
Fax:      (607) 436-2038
 
*******************************************************************
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users