My Oracle Support Banner

Extract fails with OGG-01074 INVALID CASE STATEMENT, VALUE 0 IN SETLOBRECORDGG when altering table make BLOB Column Larger (Doc ID 1472960.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


On : version, EXTRACT executable

When attempting to start the extract the following error occurs.

2012-04-23 09:34:34 ERROR OGG-01074 Invalid case statement, value 0 in setLOBRecord


The size of BLOB column was increased from 2048 to 4096

For eg:

alter table <table_name> alter column <column_name> set data type blob(4096) data capture change;


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.