Re: Function over DB Link?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 19 Jan 2006 21:17:48 +0000
Message-ID: <i600t1ls0d0s78e8qqura0c06qm1pc82m5@4ax.com>

On 19 Jan 2006 11:33:32 -0800, amerar_at_iwc.net wrote:

>I am trying to accomplish this:
>
>select forms_library.is_local(recruit_id)@xen from recruit_at_xen where
>rownum < 3;
>
>Receiving this error:
>
>ERROR at line 1:
>ORA-00923: FROM keyword not found where expected
>
>Any help from any Oracle experts?
>
>Thanks in advance.......

 SQL reference says:

[ schema. ]
{ [ package. ]function | user_defined_operator } [ @ dblink. ]
[ ([ DISTINCT | ALL ] expr [, expr ]...) ]

 So, database link after function name but before parameters.

select forms_library.is_local_at_xen(recruit_id) from recruit_at_xen
where rownum < 3;

 e.g.

SQL> select object_type from user_objects_at_test102u where object_name = 'F';

OBJECT_TYPE

---

FUNCTION SQL> select f_at_test102u from dual_at_test102;

         F

---

         1

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Jan 19 2006 - 15:17:48 CST