PLS-00201: identifier 'STDDEV_POP' must be declared

From: Sathish Kumar S <sathishs76_at_yahoo.com>
Date: 13 Aug 2003 22:47:00 -0700
Message-ID: <6f4d2429.0308132147.48d84b25@posting.google.com>

When trying to use the STDDEV_POP() analytic function inside a stored procedure i get a compilation error:

The following error has occurred:

ORA-06550: line 5, column 8:
PLS-00201: identifier 'STDDEV_POP' must be declared
ORA-06550: line 5, column 1:

PL/SQL: SQL Statement ignored
ORA-06550: line 10, column 1:

But the same STDDEV_POP() when used in a select statement directly, it gives the expected result.

I am facing this problem in Oracle 8.1.7.0.0 version. Waiting for a solution at the earliest to overcome this problem. Received on Thu Aug 14 2003 - 00:47:00 CDT