Re: Troubleshooting ORA-12704 errors

  • From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
  • To: 'oracle-l' <Oracle-L@xxxxxxxxxxxxx>, cstephens16@xxxxxxxxx
  • Date: Sat, 5 Oct 2019 15:54:36 +0100

On 04/10/2019 18:58, Mark W. Farnham wrote:

ah, SQLAlchemy, so python, so cx_oracle....

Interesting! Mark is replying to a post that I never received! :(

in theory that makes sense but dumping out the values passed into bind doesn't show any out of the ordinary characters. when we substitute the binds for literals with literal_binds, those literals all look like standard ascii values.
I imagine that Oracle knows the CSID of your binds - after all, it prints the CSID for binds in a 10046 trace, and also, in the ORA-12704 error line(s). I rather suspect that it is simply saying "are these two data items of a compatible characterset? No? Ok, ORA-12704 and dump out the details"



Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767

Other related posts: