Hi All,
I got the solution : https://www.nuomiphp.com/eplan/en/84441.html
It solved my issue and hope that this can help people solve problems with
python x oracle clob.
Thanks.
Eriovaldo
Em sáb., 4 de jul. de 2020 às 17:57, Eriovaldo Andrietta <
ecandrietta@xxxxxxxxx> escreveu:
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