I am trying to use the Rank() Function in Oracle8i PL/SQL but I am getting the message ORA-30484: missing window specification for this function. What have I missed?

    Requires Free Membership to View

Analytic functions are not supported in Oracle8i (actually from 8.1.6 onwards) in PL/SQL blocks or stored procedures. They are supported from Oracle9i. Two work around are possible:
1) Use RANK() in dynamic SQL in your PL/SQL program unit or
2) Create a view using the RANK()in your SQL query and then use the view in your PL/SQL program unit.

This was first published in June 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.