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

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_at_gmail.com> 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
>
>

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