HHH-8103 - Oracle LOBs with SequenceIdentityGenerator

Patch and test for HHH-8103 JIRA ticket.
Link: https://hibernate.atlassian.net/browse/HHH-8103

Regards,
Lukasz Antoniak