Re: Problem with dblink in Oracle 7

From: Dmitry Sirotkin <sdmitry1_at_my-deja.com>
Date: Fri, 27 Oct 2000 11:22:52 GMT
Message-ID: <8tboi9$c86$1@nnrp1.deja.com>

Hi, Marc!

> If nothing else works, create a synonym (create synonym plat_dual for
> dual_at_plaT@CYBERCARD) and use that in your pl/sql code.
>
> Marc

I've tried your solution and: 1. Synonym was created succesfully (CREATE PUBLIC SYNONYM r_SHOP FOR SHOP_at_PLAT@CYBERCARD) 2. SELECT * FROM r_SHOP works fine; 3. DECLARE N CHAR; BEGIN SELECT 'A' INTO N FROM r_SHOP; END; It gave me compilation error "identifier r_SHOP must be declared".

Dmitry.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 27 2000 - 06:22:52 CDT