Skip to main content


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: 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,

Report message to a moderator

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

Report message to a moderator

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 https://bugs.eclipse.org/bugs/show_bug.cgi?id=486883

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 21:42:44 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly