Modifying (UDATE) last inserted TABLE
I'm still seeking for a solution to my scenario:
I'm reading a foreign SQL-Syntax, convert it to Oracle PL/SQL and use the generated statements to upload the schema and content using OCI into the Oracle DB.
All went fine until the day when some character string that ought to be put into LONG columns in Oracle exceeded 4000 characters.
Strings longer that this could not be transported via OCIStmtPrepare/OCIStmtExecute (ORA-01704).
My approach is the following at the moment: skip the INSERT into that particular column (LONG) and do a OCIBindByPosition() right after that
particular insert.
My problem is: how can I address the most recent INSERT to update that particular column? I thought of writing