analytical functions and reports

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Mon, 21 Apr 2003 18:26:12 GMT
Message-ID: <8JWoa.2150$Jf.1176667_at_news1.news.adelphia.net>

Is there a patch for the following Reports that knows about analytical functions?

This works in SQL Plus, but not in Reports

      select max( date_established ) over
             ( partition by fld1, fld2 order by fld1, fld2 )
        into g_date_established
        from table

Oracle particulars:

---

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option
JServer Release 8.1.7.2.0 - Production

Reports particulars:

---

Report Builder 6.0.8.11.3
ORACLE Server Release 8.0.6.0.0
Oracle Procedure Builder 6.0.8.11.0
Oracle ORACLE PL/SQL V8.0.6.0.0 - Production Oracle CORE Version 4.0.6.0.0 - Production Oracle Tools Integration Services 6.0.8.10.2 Oracle Tools Common Area 6.0.5.32.1
Oracle Toolkit 2 for Windows 32-bit platforms 6.0.5.35.0 Resource Object Store 6.0.5.0.1
Oracle Help 6.0.5.35.0
Oracle Sqlmgr 6.0.8.11.3
Oracle Query Builder 6.0.7.0.0 - Production PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production) Oracle ZRC 6.0.8.11.3
Oracle Express 6.0.8.3.5
Oracle XML Parser 1.0.2.1.0 Production
Oracle Virtual Graphics System 6.0.5.35.0 Oracle Image 6.0.5.34.0
Oracle Multimedia Widget 6.0.5.34.0
Oracle Tools GUI Utilities 6.0.5.35.0 Received on Mon Apr 21 2003 - 20:26:12 CEST