How can I enable OLAP Window Functions

[walle]

Hi,

I'm using an Oracle 9.2.0.1.0 Test Database.
I need to use a "Rank" and a "Dense Rank" function is some queries.
Therefor the "OLAP window functions" need to be anabled.
Everything works fine on my testdatabase.
But, like always, on the production DB-server all the queries that requires those OLAP functions don't work :-(.
It is an Oracle 8.1.7 DB.

When I do an " Select * from v$option " on my testdb, I get the following result:
....
Olap Window functions | TRUE
....

The production db (8.1.7) results:
....
Olap Window functions | FALSE
....

Looks like 8.1.7 also supports the OLAP window functions.
So I guess I need to enable those f.ck... functions.
Is this just a parameter in a file of in the db??
Do I need to reïnstall Oracle? (Meens a reïnstall of th machine!)

Thanks!

 

[sem]

You may use some OLAP functions in 8i, but only within pure sql. PL/SQL doesn't support them in 8i. As a workaround dynamic sql (REF CURSOR, EXECUTE IMMEDIATE or even DBMS_SQL) may be used.

Regards, Dima

http://seminihin.narod.ru