Precompilers and OCI (MOSC)

MOSC Banner

Modifying (UDATE) last inserted TABLE

edited Jun 10, 2015 10:00AM in Precompilers and OCI (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center