MSDAORA Driver Max String Length

• mhilligas

  Ten Centuries

  Points: 1354

  More actions

  November 13, 2009 at 12:26 pm

  #213664

  I am running into a WALL.

  I am sending strings to ORACLE thru a Linked Server using MSDAORA.

  I have used this connection for many transactions without a problem.

  I have a 11K string to send and it is telling me the MAX LENGTH is 8K.

  Does anyone know if there is an updated driver or a way around this other than the obvious....SHORTEN THE STRING.

  Regards

  Michael Hilligas

• Kees Beimans

  SSC Eights!

  Points: 978

  More actions

  December 27, 2009 at 7:29 am

  #1096566

  Hi Michael,

  I guess the Oracle type you are using Varchar2() Varchar2 is limited by default to 4Kbyte characters.

  I just see one workaround: Convert the string to the Oracle CLOB type

  See also: http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/sql_elements001.htm