How to repopulate the locator - ORA-22922 - ORA-22922 nonexistent LOB value

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 4 Jul 2020 17:57:47 -0300
Message-ID: <CAJdDhaM28qTzFQFZviMj1eeB3Jap3CL1LFoBVoSrLTNLUGJt+g_at_mail.gmail.com>

Hello,

I am inserting data in several tables with CLOB column. The source database is an exadata 12.2 and target (aws machine) also is 12.2 Oracle version.
The source database has NLS_CHARACTERSET WE8ISO8859P1 and the target database has : WE8MSWIN1252.
I got success with 2 tables and I got this error : "ORA-22922 nonexistent LOB value" with another table.

I am using python language to insert with cx_Oracle. The insert command
uses data as bind variable. I saw in the gv$sqlarea.
Before insert I remove all data. The table is empty. And tried to use :

TRUNCATE and DELETE

I read in the Oracle documentation the following:

Quote
Cause: The LOB value associated with the input locator does not exist. The information in the locator does not refer to an existing LOB.

Action: Repopulate the locator by issuing a SELECT statement and retry the operation.
End Quote

How to fix it ? How to repopulate the locator ? Any experience with this error ?

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 04 2020 - 22:57:47 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Infected PC"
Previous message: Mladen Gogala: "Re: How to alter PATH_PREFIX in a PDB after creation"
Next in thread: Eriovaldo Andrietta: "Re: How to repopulate the locator - ORA-22922 - ORA-22922 nonexistent LOB value"
Reply: Eriovaldo Andrietta: "Re: How to repopulate the locator - ORA-22922 - ORA-22922 nonexistent LOB value"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message