| LONG RAW Limitation [message #36807] |
Sat, 22 December 2001 07:32  |
Nirmal TS
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
I have a stored procedure which returns via an out array parameter LONG RAW as chunks of 4k..and the total size of the parameter is above 32k...MS OLEDB for Oracle has documented a limitation of 32k for in/out parms when used in stored procedures but not with select/insert/update statements.
(Ref: MSDN/Microsoft OLE DB Provider for Oracle Tips, Tricks and Traps: LONG/LONG RAW Limitations)
I want to know if there's any limitation when using oraOLEDB?
----------------------------------------------------------------------
|
|
|
|
| Re: LONG RAW Limitation [message #36890 is a reply to message #36807] |
Tue, 01 January 2002 15:19  |
j.smith
Messages: 21
Registered: December 2001
|
Junior Member |
|
|
this does not answer your question, but i thought i might post it anyway for LONG datatypes.
"The LONG datatype is similar to VARCHAR2, except that the maximum length of a LONG value is 32, 760 bytes. Therefore, values longer than 32,760 bytes cannot be selected from a LONG database column into a LONG PL/SQL variable".
:)
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
