Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> WHERE clause truncated in trace output
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