IN my unit tests am using H2 database . IN real world am using Oracle. So we have a query which runs fine in Oracle:
update emp.emp_data set current_state = empty_clob()
where dbms_lob.compare(current_state, empty_clob()) != 0
The error we get is :
org.h2.jdbc.JdbcSQLSyntaxErrorException: Schema "DBMS_LOB" not found; SQL statement:
update emp.emp_data set current_state = empty_clob()
where dbms_lob.compare(current_state, empty_clob()) != 0 [90079-224]
am using h2 version 2.2.224 . any clues ?