ORA-01733 -virtual column not allowed [message #37608] |
Fri, 15 February 2002 08:46 |
Radha Krishna Harathi
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
Hi,
We are trying to execute the following code in 8.0.5:
SELECT FROM remote_table X
WHERE
DECODE(X.col, local variable, Remote_Pkg.function(parm),'N') = 'N'
Runtime error for above code is ORA-01733 - virtual column not allowed.
The error is being caused by the DECODE that is referencing remote table and also has a RPC. The conbinaion of remote table lookup and RPC is what causing the problem. If either one is changed it works fine i.e. If we use local tble with RPC or Remote table with local procedure call works fine.
Any way out of this??
Thanks!
|
|
|
|