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 -> Re: ProC fills varchar2 with blanks ???

Re: ProC fills varchar2 with blanks ???

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1997/06/26
Message-ID: <5ou1vu$lof$1@client3.news.psi.net>#1/1

In article <33B26859.7628_at_ats.nld.alcatel.nl>, Bas Ven <ven_at_ats.nld.alcatel.nl> wrote:
>Is this a ProC 'feature' or is it possible to tell ProC not to do
>this by setting some variable ?

in pro*c you must select varchar2 datatypes into variables declared VARCHAR. it is a structure that contains a length part and a char array.

or you may declare the variable char* (pointer to char) and you supply the storage area.

in these methods no extra spaces are stored.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.
Received on Thu Jun 26 1997 - 00:00:00 CDT

Original text of this message

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