Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Pro*C bug?

Pro*C bug?

From: Jared MacDonald <jdm42_at_my-deja.com>
Date: 2000/03/17
Message-ID: <8aubfb$754$1@nnrp1.deja.com>#1/1

Hello. I was wondering if anyone out there had experience with attempting to get data from a RAW through Pro*C, where the data length of the raw was greater than 16k.

RAWs can hold up to 32k, and hence Pro*C limits the size of a VARCHAR array that can be filled from a RAW to size 32767. However, because Oracle converts the raw data to a character hexadecimal representation when doing the RAW -> VARCHAR conversion, each byte in the original raw now takes two characters -- and hence, the data one can access is effectively reduced to 16k!

Is this completely incorrect?? Anyone else have this problem?

Jared

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 17 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US