Oracle EMPTY_BLOB()

[Kevin O'Neal]

When using `Mode=oracle`, I am seeing the following error:

org.h2.jdbc.JdbcSQLSyntaxErrorException: Function "EMPTY_BLOB" not found; SQL statement

I'm assuming that this is because EMPTY_BLOB() and EMPTY_CLOB() have not been implement. Is that correct? and if so, should I raise and issue in github?

Thanks,

Kevin

[Ritu Jain]

Yes H2 database does not have support for all Oracle functions

In this case, you can use Create Alias to write your own implementation with same name.

Thanks,

Kevin

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/76ded5b9-16f8-4217-9643-63a412879378n%40googlegroups.com.

[KevinO]

Thanks Ritu for the information!

To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAK_22rYJnB5Z_7QXr3pn6z%2B%2BiUhsG5GUMev3PPShqJatfJvfwA%40mail.gmail.com.

[Ritu Jain]

Hey Kevin

I am not able to see H2 console while executing my application

Can you suggest any property or setting that I may have missed.

I really need to see the H2 console to look at the data created.

To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAF9RioSzKFFUu5c_6O32sSrxpeE7vvWc4fY5gz1DgUXOQd92vQ%40mail.gmail.com.