Home » RDBMS Server » Performance Tuning » calling a function from remote db (8.1.6.3)
calling a function from remote db [message #300123] Thu, 14 February 2008 05:16 Go to next message
fortheppl
Messages: 9
Registered: January 2008
Junior Member
hi
when my developer is trying to call a function from remote db hez gettin an error

SELECT kppd.IN_STATUS('9846500105','balance') FROM dual@hicash
*
ERROR at line 1:
ORA-00904: invalid column name


remote db version 9.2.0.6

local db version:8.1.6.3

how to solve it?

Report message to a moderator

Re: calling a function from remote db [message #300136 is a reply to message #300123] Thu, 14 February 2008 05:58 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
select function@link(...) from ...

Regards
Michel

Report message to a moderator

Previous Topic: disk read speed
Next Topic: need help in tuning this query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 04:50:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.