Re: PLS-00201: identifier 'STDDEV_POP' must be declared

sathishs76_at_yahoo.com (Sathish Kumar S) wrote in message news:<6f4d2429.0308132147.48d84b25_at_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.

Just read the manual and search google for pls-201. And don't start *demanding* a solution.

Sybrand Bakker
Senior Oracle DBA Received on Thu Aug 14 2003 - 06:01:38 CDT