ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum string length: SQL & PL/SQL

469860Dec 25 2006 — edited Jul 17 2007

A very simple question... What is maximum string length, supported by ODP.NET when transporting values to/from DB?

I cant found it in documentation, and make some experiments. Some results is discouraging (for me):

* Input to SQL statement: 2000 National / 4000 ASCII characters, its OK.
* Output from SQL query to DataReader: 2000 National / 4000 ASCII characters, its OK.

* Input to PL/SQL: 16256 National / 32512 ASCII characters. (???? Strange numbers)
* Output from PL/SQL: 10837 National / 10838 ASCII charactes (???? Strange numbers). OracleParameter.Size = 10837, increasing doesnt change value limit.

Why PL/SQL input/output string limits are so strange?
What causes this limits?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2007

Added on Dec 25 2006

#odp-net

5 comments

9,989 views