Re: create procedure problem

"Jordan" <warlord_at_netvigator.com> wrote in message news:9o27rj$q741_at_imsp212.netvigator.com...
> Can anyone tell me what is my following function problem. After typing
the
> END; , sql still waiting for me to type the command, not executing this
sql
> statement, thanks.
>
> CREATE OR REPLACE FUNCTION MY_SIN(DegreeIn IN NUMBER)
> RETURN NUMBER
> IS
> pi NUMBER := ACOS(-1);
> RadiansPerDegree NUMBER;
>
> BEGIN
> RadiansPerDegree := pi/180;
>
> RETURN(SIN(DegreesIn*RadiansPerDegree));
> END;
>
>

CREATE OR REPLACE FUNCTION MY_SIN(DegreeIn IN NUMBER)  RETURN NUMBER
 IS

   pi                    NUMBER := ACOS(-1);
   RadiansPerDegree      NUMBER;

 BEGIN
   RadiansPerDegree := pi/180;

   RETURN(SIN(DegreesIn*RadiansPerDegree));  END;
/

Note the difference of 1 single character!

Please read the pl/sql manual.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 16 2001 - 08:32:00 CDT