Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

BIX Insert query displays ORA-24816 when multiple clob columns

SA-78894

Summary



In a Business Intelligence Exchange (BIX) Extract rule, multiple properties (in the Extract rule) are mapped as Long text to a CLOB column in an Oracle database. These Long text properties, on different pages, are all extracted to the same target top level table. ORA-24816 occurs when the work objects are extracted.


Error Messages



Severe SQL Exception: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

java.sql.BatchUpdateException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or CLOB column
 at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296) ~[ojdbc7.jar:12.1.0.2.0]
 at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246) ~[ojdbc7.jar:12.1.0.2.0]



Steps to Reproduce

  1. Create an Extract rule with any Work class and set the type as a Database Extract.
  2. Create a main database table for the main class.
  3. Add a page.
  4. Add sub pages to the main page as part of the Work class.
  5. In one of the sub pages,

    - Add a pyNote at the end of the sub page
    - Set the column type as Long text
    - Set the length as 8000 characters

     
  6. After adding pyNote to the end of the last sub page, add another parent page to the main class.
  7. Include additional fields to the parent page.
  8. Create the table in the database.
  9. While creating the table in the database, define pyNote datatype as a CLOB and execute the query.
  10. Return to the Extract and run it manually. Error is generated in the logs after the Extract is run because the Extract is unable to add the CLOB columns at the end of the Insert query.


Root Cause



A defect or configuration issue in the operating environment.
Under certain circumstances, Oracle requires all the Bind variables, in an Insert statement for CLOB columns, to be appended at the end of the list.



Resolution



Apply HFix-52259.
Suggest Edit

Published May 2, 2019 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us