Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Haidong Ji Oracle and SQL Server Data Interoperability Issues - Part 1 RE: Oracle and SQL Server Data Interoperability Issues - Part 1

  • June 13, 2006 at 7:34 pm

    #643535

    There's another subtle difference about varchars.  The maximum field width is 4000 as you mentioned, but the declaration of a varchar variable in PL/SQL can be as large as 32767 (32Kb - 1).

    Cheers,

    Win