create function problems

I think I need some help to create an Oracle function. I created the table IVA like this one:

SQL> desc iva;

 Name                                      Null?    Type
 ----------------------------------------- -------- 


----------------------------

 DATA_INIZIO                               NOT NULL DATE
 DATA_FINE                                          DATE
 ALIQUOTA                                  NOT NULL NUMBER(3,1)

SQL> select * from iva;

DATA_INIZI DATA_FINE ALIQUOTA
---------- ---------- ----------

1900-01-01 2011-09-16         20
2011-09-16                    21

and I want to create a function to returns the value of "aliquota" valid at a given date.

SQL> CREATE OR REPLACE Function aliquota_iva ( data IN date)   2 RETURN number
  3 cnumber number(3,1);
  4 BEGIN SELECT aliquota INTO cnumber FROM iva WHERE data BETWEEN data_inizio AND data_fine OR data >= data_inizio AND data_fine IS NULL;   5 RETURN (cnumber);
  6 END;
  7 /

Warning: Function created with compilation errors.

What's wrong with this code?

j

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 23 2011 - 04:28:21 CDT