OTN users,
Listed below is compile time error I received when compiling a pl/sql function to compute the end of the month. You all are welcome to use it if you can help decipher the cryptic error message.
SQL> create or replace function end_of_month(
2 m in varchar2, y in varchar2
3 ) return varchar2 AS
4 eom_val;
5 BEGIN
6 select to_char(last_day('01'||'-'||'m'||'-'||'y'))
7 into eom_val
8 from dual;
9 return eom_val;
10 END end_of_month;
11 /
Warning: Function created with compilation errors.
SQL> show erro
Errors for FUNCTION END_OF_MONTH:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/8 PLS-00103: Encountered the symbol ";" when expecting one of the
following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "exception" was substituted for ";" to continue.