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 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
Previous Topic:Compound Primary Key in InheritanceType.JOINED
Next Topic:CacheRetrieveMode.BYPASS of EclipseLink is not useful.
Goto Forum:

Current Time: Mon Nov 30 20:48:05 GMT 2015

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

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