Hi, We are using Open JPA 2.2.2 in Oozie project.
We have a mixture of lob and varchar in our tables. We recently converted few of lob's to varchar (4000). Now sometimes, we are seeing the following error while inserting in table: Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column It seems that ORA-24816 happens when lob's are not at the end of the insert/update list. 2 questions: 1. Is it possible to arrange the columns in a particular order (order defined in java file or based on some other order) so we can have all lob's at the end? 2. We never encountered this error before even though we had 6 lobs and almost dozen of varchars in our table. We converted 3 lobs to varchar2(4000) and started seeing this issue intermittently. Does anyone suspect that this conversion from lob to varchar has a role to play? Thanks, Virag
