Re: Troubleshooting ORA-12704 errors

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 02 Oct 2019 21:15:40 +0100
Message-ID: <53BED723-06EE-467C-BDC1-F71C7121052D_at_dunbar-it.co.uk>

Possibly, one of your mismatching character sets is csid=2000 which is AL16UTF16, the other is csid=873 which is AL32UTF8. The two mismatching items are both dty=1 which makes them both NVARCHAR2 or VARCHAR2.

If you have the bind information in the trace file, my free eBook on trace files might help identify which two items are mismatching. Grab a copy, if you wish, from https://github.com/NormanDunbar/OracleTraceFilesExplained/releases. The appendices have information on character sets, data types and such like used by the binds.

I'm not sure what most of the rest of those parameters are, sorry.

HTH Cheers,
Norm.

--

Sent from my Android device with K-9 Mail. Please excuse my brevity.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 02 2019 - 22:15:40 CEST

This message: [ Message body ]
Next message: Adric Norris: "Re: SCAN addresses and TNSNames"
Previous message: Chris Stephens: "Troubleshooting ORA-12704 errors"
In reply to: Chris Stephens: "Troubleshooting ORA-12704 errors"
Next in thread: Jonathan Lewis: "Re: Troubleshooting ORA-12704 errors"

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

Original text of this message