Re: database link and function calls

From: Ian <ian.downham_at_which?.net>
Date: Sat, 06 Feb 1999 09:54:34 +0000
Message-ID: <79h3s9$2gj$1@nclient1-gui.server.which.net>

Create a synonym to the remote function across a database link

ie create synonym my-synonym for remote_schema_name.function_at_database link

Then just use the synonym

Think thats right ?

Ian

Theodore Clement wrote:

> Does anyone know is you can call a function on database1 by using a database
> link from database2? Is there any special syntax?
>
> We are trying to share account number generation function between 2 schema.
> This process is bassed on a sequence number with a check digit routine. Is
> there a better way to do this?
>
> Thanks,
>
> Ted Clement
> ted-clement_at_worldnet.att.net

--
Click here to e-mail me mailto:ian.downham_at_which.net Received on Sat Feb 06 1999 - 03:54:34 CST