Eclipse Community Forums: EclipseLink » ORA-24816 on insert with LOB

Home » Eclipse Projects » EclipseLink » ORA-24816 on insert with LOB

ORA-24816 on insert with LOB [message #645980]

Tue, 21 December 2010 08:10

Eclipse User

Hi guys,

When we try to insert a record we get the following error:
Internal Exception: java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.

A bit of googling learns that the LOB column should be used last in the order of insert columns. (Although I am not sure what to do with multipe LOB coumns). Reference: http://forums.oracle.com/forums/thread.jspa?threadID=415560

Now I am not sure where this should be arranged, in EclipseLink, or the Oracle driver.

Anyone able to help me on this one?

Kind Regards,

Re: ORA-24816 on insert with LOB [message #647121 is a reply to message #645980]

Tue, 04 January 2011 11:38

Eclipse User

What Oracle JDBC driver/version are you using? The thin driver on older versions had a 4k limit. EclipseLink supports using a locator for Lobs to work around this. Ensure your Lob is mapped as a Lob and you are using the correct OracleXXPlatform.

Re: ORA-24816 on insert with LOB [message #1721775 is a reply to message #645980]

Sat, 30 January 2016 01:24

Eclipse User

This is an old post but it is the #1 result for this problem which is still occurring. I created a bug report and document a possible work around by overriding the insert statement that eclipselink uses in https://bugs.eclipse.org/bugs/show_bug.cgi?id=486883

Previous Topic:	EclipseLink on Android?
Next Topic:	Merge with Null being ignored

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 13:57:15 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter