Re: VARRAW host variable into VARCHAR2 field

M. Shawkat Hasan wrote:
>
> In a Pro*C program I define a VARRAW type equivalence by reference
> and insert data into a varchar2 field through this VARRAW variable.
> The problem is, to be successful, the VARCHAR2 data field length
> has to at least twice the length of the length of the inserted
> VARRAW variable.
>
> My question: Is it normal ? does ORACLE translate VARRAW data to
> twice its specified length (in var->len) when storing in a VARCHAR2
> field ?
>
> I'd appreciate if anybody knaow anything about this situation. Please
> email me a copy of the response. Thanks,

I believe oracle translates the RAW data to hex when you select into a character type.

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)