Home » SQL & PL/SQL » SQL & PL/SQL » LONG RAW Limitation
LONG RAW Limitation [message #36807] Sat, 22 December 2001 07:32 Go to next message
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 Go to previous message
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".

:)

----------------------------------------------------------------------
Previous Topic: Help needed urgent
Next Topic: Need Help For Trigger
Goto Forum:
  


Current Time: Mon Aug 03 05:16:37 CDT 2020