From oracle-l-bounce@freelists.org  Fri Jul  8 13:15:07 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id j68IF77Q023047
 for <oracle-l@orafaq.com>; Fri, 8 Jul 2005 13:15:07 -0500
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j68IF1IP023023
 for <oracle-l@orafaq.com>; Fri, 8 Jul 2005 13:15:02 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C69881CAA11;
 Fri,  8 Jul 2005 13:14:43 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 09560-08; Fri, 8 Jul 2005 13:14:43 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B8111CA942;
 Fri,  8 Jul 2005 13:14:43 -0500 (EST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=cl6XA1bQEErZGO/FPtgn/8raLL87DnKe2aNUEXClHOTBVurC2Ljqb6XE2iNe3bdpG4rU3gx8cjWZg5HRXYSy+qCtGXG/ZNiwpFEdeZvjVHY7HeBkGRPQ3DqNAGqWn9FxPmHkU8lW+q9bLj6M43aZqZxORaz5V/Jvd/K3vVIDiP4=
Message-ID: <bf463805070811123a080c74@mail.gmail.com>
Date: Fri, 8 Jul 2005 19:12:48 +0100
From: Jared Still <jkstill@gmail.com>
To: rlsmith@kmg.com
Subject: Re: Compile Procedure with Synonym/Dblink Oracle 9.2
Cc: Oracle-l <oracle-l@freelists.org>
In-Reply-To: <270A0BDDFDE54E41B78F0F06D82A66B801346B2F@okcexg3.kmg.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_553_18515740.1120846368996"
References: <270A0BDDFDE54E41B78F0F06D82A66B801346B2F@okcexg3.kmg.com>
X-archive-position: 22258
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: jkstill@gmail.com
Precedence: normal
Reply-To: jkstill@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net
X-mailscan-MailScanner-Information: Please contact the ISP for more information
X-mailscan-MailScanner: Found to be clean
X-MailScanner-From: oracle-l-bounce@freelists.org
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on 
 air891.startdedicated.com
X-Spam-Status: No, hits=-2.9 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE 
 autolearn=ham version=2.63
------=_Part_553_18515740.1120846368996
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Ron,

Can you create a small test case for this?

That will validate whether or not you are able to compile
a procedure that uses a synonym with dblink.

If that succeeds, you need to then determine why the
other procedure is failing.

A bug perhaps.


--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On 7/8/05, Smith, Ron L. <rlsmith@kmg.com> wrote:
>=20
> They are both there and valid.
>=20
>

------=_Part_553_18515740.1120846368996
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Ron,<br>
<br>
Can you create a small test case for this?<br>
<br>
That will validate whether or not you are able to compile<br>
a procedure that uses a synonym with dblink.<br>
<br>
If that succeeds, you need to then determine why the<br>
other procedure is failing.<br>
<br>
A bug perhaps.<br>
<br>
<br>
-- <br>
Jared Still<br>
Certifiable Oracle DBA and Part Time Perl Evangelist<br>
<br>
<br><br><div><span class=3D"gmail_quote">On 7/8/05, <b class=3D"gmail_sende=
rname">Smith, Ron L.</b> &lt;<a href=3D"mailto:rlsmith@kmg.com">rlsmith@kmg=
.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D"border=
-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-lef=
t: 1ex;">
They are both there and valid.<br><br></blockquote></div><br><br><br>

------=_Part_553_18515740.1120846368996--
--
http://www.freelists.org/webpage/oracle-l