Re: ProC fills varchar2 with blanks ???

From: Guna Govind <guna_at_gwcom.com>
Date: 1997/07/03
Message-ID: <33BC3362.2E3B@gwcom.com>#1/1

Markus Schöpflin wrote:
>
> Use the datatype STRING instead of VARCHAR2 (which is indeed blank
> padded).

  Yep..STRING is the only way i could make Oracle to return without padding blanks to the field. BUT, how do i handle this for a structure ?

I can't do a

     typedef char asciiz[40];
     EXEC SQL TYPE asciiz IS STRING(40) REFERENCE;

for every struct members.

  In my case i'm doing embedded SQL and i haven't got a clue from anybody (including ORACLE SUPPORT GROUP, TAR# 10132405.6) on handling this ? my dynamic sql statement ?,

    EXEC SQL SELECT * INTO :myrec FROM MYTABLE WHERE id = 5;

here myrec is a simple structure with few char array members..

regards.
Guna Govind

-- 
 ----------------------------------------------------------------
| General Wireless Comm. Inc. | email: guna_at_gwcom.com            |
| 3350 Scott Blvd. Bldg# 36   | phone: (408) 986 8988 Ext.128    |
| Santa Clara, CA 95054       | pager: (408) 581 4268            |
|                             | page-mail: 1617196_at_pagemart.net  |
 ----------------------------------------------------------------

Received on Thu Jul 03 1997 - 00:00:00 CDT