Re: Database links and stored procedures

From: <dwilliams_at_lifetouch.com>
Date: 2000/06/26
Message-ID: <8j8ani$qdl$1@nnrp1.deja.com>#1/1

According to the PL/SQL manual, the proper syntax would be: foo.bar_at_fubar.foobar.com('Hello world'); I haven't tried this, just quoting what the manual has.

In article <8j6ivc$sik$1_at_slb3.atl.mindspring.net>, "Matt Houseman" <mhousema_at_ix.netcom.com> wrote:
> All,
>
> What is the correct syntax when executing a stored procedure with
parameters
> over a DB link?
> I've tried:
> SQL> exec foo.bar('Hello world')@fubar.foobar.com;
>
> But the parser gags on the '@'. Is there any to do this? Thanks...
>
> Matt
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 26 2000 - 00:00:00 CDT