Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> WHERE clause truncated in trace output

WHERE clause truncated in trace output

From: <bsandell_at_gmail.com>
Date: 22 Aug 2005 13:18:49 -0700
Message-ID: <1124741929.523407.251560@g49g2000cwa.googlegroups.com>


Has anyone seen this behavior before? This a query from Oracle forms on Oracle 9.2.0.5. The queries come from two different systems, one where Table "tbl" is an actual table, one where table "tbl" is a single table view that includes some user defined function calls. Note on the query for the table that the Where clause is complete. On the query for the view, the where clause is gone, except for the letter "W".

TRACE OUTPUT in query from TABLE
SELECT ROWID, ...
FROM tbl WHERE ROWID=:1 FOR UPDATE OF MY_ID NOWAIT

TRACE OUTPUT in query from VIEW
SELECT ROWID, ...
FROM tbl W FOR UPDATE OF MY_ID NOWAIT

Any help would be greatly appreciated.

Thanks. Received on Mon Aug 22 2005 - 15:18:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US