guid oracle managed driver

30 views

Skip to first unread message

Sergey Baranov

unread,

Jan 24, 2017, 4:17:47 PM1/24/17

to nhibernate-development

Hello!
It seems that Guid (Guid.Comb, Guid.Native) generator doesn't work against Oracle database in recent versions of NHibernate.

When inserting new entity with Guid as id in the generated sql Guid is inserting into raw(16) column as 0xFE..12AB but Oracle is inspecting 'FE..12AB' (with quotes). Hence we receive Ora-00932 expected NUMBER got BINARY.

According to Oracle dialect (both Managed and Unmanaged actually) there is a substitution of DbType.Guid with DbType.Binary because DbType.Guid is not unsupported by Oracle provider (?). But this is all what I know for now.

If there are any people who successfully use Guid.Comb generator with Oracle 12c database (and managed driver) would you please confirm that this is working combination.