Invalid character

Liquibase Development
1

Hi everybody,

this is my script:

    Reason: liquibase.exception.DatabaseException: ORA-00911: invalid character [Failed SQL: CREATE F?UNCTION ?CHECKDAT?EINTERSE?CTED ( ?

range?_start ? DATE, ?

range?_end

? DATE, ?

date_?start

? DATE, ?

date_?end

? DATE ?) ?

RETUR?N SMALLI?NT ?IS ?

my_da?te_start?

DATE; ?

my_da?te_end ?

DATE; ?BEGIN ?

my_da?te_start? := NVL ?(date_st?art, ran?ge_start?); ?

my_da?te_end :?= NVL (d?ate_end,? range_e?nd); ?

IF (m?y_date_s?tart > m?y_date_e?nd) ?

THEN ?

RE?TURN 0; ?

END I?F; ?

IF ( ? range_?start BE?TWEEN my?date_st?art AND ?my_date?end ?

O?R range_?end BETW?EEN my_d?ate_star?t AND my?_date_en?d ?

O?R (range?_start <?= my_dat?e_start ?AND rang?e_end >=? my_date?_end) ?

O?R (range?_start >?= my_dat?e_start ?AND rang?e_end <=? my_date?_end) ?

) ?

THEN ?

RE?TURN 1; ?

ELSE ?

RE?TURN 0; ?

END I?F; ?END;]

Alessio

2

The file starts with   <?xml version="1.0" encoding="UTF-8" standalone="no"?>

3

Check the encoding of your file and ensure that it is UTF-8 and not something like Windows-1252.

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

4

Can you open the file in something like Notepad++ and see what encoding the file actually is in? The header might say UTF-8, but that may or may not be correct.

The question marks interspersed in the exception output are an indication that somewhere along the way the characters are not being correctly interpreted. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/