1 Reply Latest reply: May 30, 2013 9:15 AM by 1007042 RSS

    Multi-byte CLOB column with Pro*C: missing documentation or example

    1007042
      Where could i find a clear description of the expected in/out values when using the "EXEC SQL LOB READ/WRITE ..."?
      I cannot get this notation to work properly in all cases, when manipulating multi-byte data (UTF8) with CLOB columns.
      All references i could find refer to, either BLOB columns (not CLOB), or single-byte strings.
      And all articles are based on an example, with few explanations, like the following checkin/checkout samples:
      http://docs.oracle.com/cd/A87860_01/doc/appdev.817/a76940/adl09p16.htm#734232
      http://docs.oracle.com/cd/A87860_01/doc/appdev.817/a76940/adl09p17.htm#734690

      When trying to mimic these examples, i always meet issues:
      - the amount of data seems to be counted sometimes as bytes, sometimes as characters
      - the best i can do works well for most cases, but when entering greek or cyrillic text (i.e. all characters being multi-byte), i meet errors saying that too much or too few data is provided

      A reference documentation of these Pro*C notations (EXEC SQL LOB READ/WRITE), or an example using specifically UTF8 in CLOB, would be a great help to me.
      Thanks

      Edited by: C.Clouard on May 7, 2013 10:21 AM