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
Karma: 0
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?
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
select function@link(...) from ...

Regards
Michel
Previous Topic: need help in tuning this query
Next Topic: Procedure is running from more than 3 hrs but do not return the results
Goto Forum:
  


Current Time: Tue Aug 22 11:50:06 CDT 2017

Total time taken to generate the page: 0.31192 seconds