Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> db jobs problem with DB-links !

db jobs problem with DB-links !

From: <sokol_at_opsb.ru>
Date: Fri, 11 Sep 1998 04:49:55 GMT
Message-ID: <6taa5i$8h0$1@nnrp1.dejanews.com>


Please help!

If I'm call stored procedure which do SELECT from remote DB via DB-Link inside job, I very often get error "TNS could not resolve service name"

If I'm call this procedure from sqlplus (ON SERVER SIDE) all Ok!.

Both cases using one TNSNAMES.ORA!

Very much tanks.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 10 1998 - 23:49:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US