Devart Forums

Hi,

I get all sorts of errors when trying to work with NCLOB data.

For starters, trying to save UNICODE text fails with:
ORA-22993: specified input amount is greater than actual source amount

If I save the data with UTF8 encoding, I get some strange characters in a data grid. Upon retrieval, it's all like this upside down question marks.


Any idea how to work with this data?

With regards,

Martijn Tonies
Upscene Productions

Hi Martijn,

I'm working with NCLOB datatype in OCI mode (ora 11 client), D2010, latest ODAC and I don't appear to have any problems. Unicode data inserts and updates of NCLOBs work well. I suspect Devart will need a bit more information about your configuration to help. They'll definitely need to know your ODAC version, if you are using direct mode and also your Oracle Client version (if not using direct mode.) If you are using the Oracle client make sure that it's not older than your server version. They may also need a short code example that shows the problem.

-Mark

Hello

Please specify your: ODAC version, Delphi version, Oracle client and server version, which connection mode do you use: OCI or Direct, Unicode or not. Also please provide code that converts you text to UTF8 and writes it to NClob field.

You should keep in mind that NClob store text in the UTF16 format. Try not to convert your text to UTF8 manually. Oracle client converts text to the necessary encoding automatically.