Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS-00201: identifier 'STDDEV_POP' must be declared

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

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 14 Aug 2003 05:36:46 -0700
Message-ID: <725736ef.0308140436.3853a503@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US