Not very good with pl/sql yet so it does help when I get pointed in the right direction, although understanding what it was doing will take me a little longer to work out!!!

Hi All, I have been having issues while updating CLOB columns into Oracle 12.1.0.2 . We made sure that table has all CLOB columns at the end and DATASTAGE query also has all CLOB fields at the end but still UPDATE alone failes with below error while INSERT just works fine CLOB field is used as Long Var Char datatype in datastage,even tried using Long NVar Char and explored lots of options mentioned in online and forums still no go.

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from Tech Target experts.

During a recent migration project for one of our customers, I needed to export certain XML rows from a Novell Sentinel 6.1 Oracle 10G R2 Hotfix 4 Database.

Every window in SQL Workbench/J can be resized and will remember its size.

DW_PRODUCT_EVALUATION_Updates,0: The OCI function OCIStmt Execute returned status -1.

Error code: 24,816, Error message: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.

What is the reason for this , i think i am not specifiyg the clob properly in query.

Following is the query and the error stack trace i see in jboss log.