Facing issue with H2 and dbms_lob

30 Views Asked by At

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 ?

0

There are 0 best solutions below