SELECT O."OBJECT_ID", 
   O."CHANNEL_ID", 
   O."IOV_SINCE", 
   O."IOV_UNTIL", 
   O."USER_TAG_ID",
   O."SYS_INSTIME",
   O."LASTMOD_DATE",
   O."ORIGINAL_ID",
   O."NEW_HEAD_ID",
   O."S"
FROM ST_CLIENT."PDBST002_F0001_IOVS" O,
   ST_CLIENT."PDBST002_F0001_CHANNELS" C 
WHERE C."HAS_NEW_DATA" = :"hasNewData" 
AND C."LAST_OBJECT_ID" = O."OBJECT_ID" 
ORDER BY C."CHANNEL_ID" ASC


Tested on Oracle 11g with COOL 2.2.1 and the problem is still there.

-- RomainBasset - 13 Sep 2007

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2007-10-17 - RomainBasset
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Main All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback