Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01733 -virtual column not allowed
ORA-01733 -virtual column not allowed [message #37608] Fri, 15 February 2002 08:46 Go to next message
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!
Re: ORA-01733 -virtual column not allowed [message #37623 is a reply to message #37608] Mon, 18 February 2002 00:24 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
replace local variable with a constant.it should work fine
Previous Topic: Automating the Insertion of rows from several different queries
Next Topic: response time
Goto Forum:
  


Current Time: Fri Mar 29 00:33:52 CDT 2024