Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: if statement inside function
In message <1140027860.478945.246030_at_g14g2000cwa.googlegroups.com>,
drdave_at_canoemail.com writes
>New to Oracle and cant understand why my code is not working ..
>
>FUNCTION "VARIATION_ID" ("range_id" IN VARCHAR2) return NUMBER is
> rangebig NUMBER;
>
>BEGIN
>
>
> SELECT max(minimum_wage_variation_id) as bigrange into rangebig
> FROM minimum_wage_variation
>
> IF range_id = 1 THEN
> WHERE minimum_wage_variation_id < 100
> ELSE
> WHERE minimum_wage_variation_id > 100
> END IF;
>
>
> RETURN rangebig;
>END;
>
>error:00933 sql command not properly ended, yet if I put a semicolon on
>the where clauses it throws an error on the else clause..
>
>thx.
>
>Dave
>
You can't mix SQL and procedural code - SQL statements need to be
complete.
You should read the PL/SQL reference manual <http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.ht m>.
-- Jim Smith I'm afraid you've mistaken me for someone who gives a damn.Received on Wed Feb 15 2006 - 12:38:10 CST