Updating a clob Yahoo chat onlinesex
Error code: 24,816, Error message: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column.(CC_Ora Statement::execute Update, file CC_Ora Statement.cpp, line 2,382) Any suggestion is much appreciated,as its an hot topic in my project Thanks, Rani Try creating an user define update SQL by placing all the clob fields in the last and there should be not other update/insert fields after the clob fields.You can also perform more complicated updates in Oracle.You may wish to update records in one table based on values in another table.
Also, super-fast storage makes a big difference for inserts, and SSD have do well over 100,000 rows per second insert rates. I have a variable in my script: v_field1 VARCHAR2(32000); This is part of a cursor record: v_mf_table IS TABLE OF mf_detail%ROWTYPE INDEX BY BINARY_INTEGER; v_mf_record v_mf_table; I use a FORALL to insert the data into a table: FORALL x IN v_mf_record. v_field1 is My bad, sorry: FOR x_rec IN mf_monthly(v_mf_record(v_rec).ticker) LOOP v_monthly_data := v_monthly_data