Oracle-L: Case Statements, Distributed Queries, ORA-22804 Errors

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Mon, 12 Aug 2002 11:28:18 -0800
Message-ID: <F001.004B21C5.20020812112818@fatcity.com>

When one tries to use a case statement, okay it's really a function, over a database link Oracle objects:

ORA-22804 remote operations not permitted on

object tables or user-defined type columns Cause: An attempt was made to perform queries or DML operations

       on remote object tables or on remote table columns whose
       type is one of object, REF, nested table or VARRAY.

Action: Remove the reference to remote tables in the statement

There are no object tables, varrays or anything of that ilk involved in the statement. Why the error?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 12 2002 - 14:28:18 CDT