Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » ORA-24816 on insert with LOB
ORA-24816 on insert with LOB [message #645980] Tue, 21 December 2010 13:10 Go to next message
ronald.iwema is currently offline ronald.iwemaFriend
Messages: 1
Registered: December 2010
Junior Member
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:

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 16:38 Go to previous messageGo to next message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

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.

James : Wiki : Book : Blog : Twitter
Re: ORA-24816 on insert with LOB [message #1721775 is a reply to message #645980] Sat, 30 January 2016 06:24 Go to previous message
Matthieu Heimer is currently offline Matthieu HeimerFriend
Messages: 1
Registered: January 2016
Junior Member
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
Previous Topic:EclipseLink on Android?
Next Topic:Merge with Null being ignored
Goto Forum:

Current Time: Mon Apr 23 21:31:42 GMT 2018

Powered by FUDForum. Page generated in 0.01862 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software