EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Calling Remote Oracle Function  XML

Forum Index » Standard Server
Author Message
[Post New]5 Mar 2010 15:33:25
    Subject: Calling Remote Oracle Function
[Up]
samba_emani

New member

Joined: 5 Mar 2010 15:19:53
Messages: 1
Offline
Hi,

Does EntrerpriseDB support call to remote Oracle procedure/function?

Ths is what I did. Any input is appreciated

I have a function "f_func_ora(i_arg1 varchar2) return varchar2" in oracle database xe.

I created a DBlink "xe" in EntrerpriseDB for oracle database xe.

Now I am trying to call remote function using "select f_func_ora@xe('temp') from dual" which comes with the error

ERROR: function f_func_ora() does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

Thanks,
Samba

[Post New]8 Mar 2010 21:16:23
    Subject: Re:Calling Remote Oracle Function
[Up]
scottiebo

Senior member
[Avatar]

Joined: 23 Oct 2005 21:05:02
Messages: 197
Offline
I seem to recall that in the release 2 version of 8.3, this is a limitation.
--Scottie
 
Forum Index » Standard Server
Go to:   
Powered by JForum 2.1.8 © JForum Team