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.

Hi,

I'm not absolutely sure about this, but I know that use of the STDDEV_POP function inside PL/SQL blocks was not supported in 8.1.6 - whether this is the case in 8.1.7 I don't know. I can confirm that I can replicate your error using version 8.1.7.0.0. Note 100557.1 in MetaLink mentions this.

Regards,

Tim Kearsley
Database Manager
Milton Keynes Council Received on Thu Aug 14 2003 - 07:36:46 CDT