Re: create procedure problem

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sun, 16 Sep 2001 13:34:04 GMT
Message-ID: <Xns911E42CF6348ASunnySD@24.0.3.73>

"Jordan" <warlord_at_netvigator.com> wrote in 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;
>
>
>

Add a slash "/" on the line following the END: statement. Received on Sun Sep 16 2001 - 08:34:04 CDT