Migrating sql/ds to Oracle

From: Philippe Olivero <pho_at_cc.in2p3.fr>
Date: 1996/01/08
Message-ID: <4crgrn$isc_at_ccpnws.in2p3.fr>#1/1


I'm migrating a C-application using SQL/DS (IBM/VM) to Oracle under Unix. Could anybody explain that :
I have an sql-table T1 with a column C1 declared as

        C1 char not null ,
and other columns.
Table T1 has been filled by specific Oracle tools, out of the application.  C1 contains uppercased letters.

I want to get the value of C1 for one row of that table, in C-written application:
...
EXEC SQL BEGIN DECLARE SECTION
  char loc_for_C1;
   ....
EXEC SQL END DECLARE SECTION
   ...

EXEC SQL SELECT C1

         INTO   :loc_for_C1
         FROM   T1
         WHERE  where-clause 

Sqlcode is then correct, but loc_for_C1 contains '\0';

Is this construction forbidden under Oracle?

 Am I obliged to declare loc_for_C1 as char loc_for_C1[2] ? I don't want.  Any explication or help ?
 Thanks

-- 
Philippe Olivero                       e-mail pho_at_cc.in2p3.fr
Centre de Calcul de l'In2p3          
29, Bld du 11 Novembre 1918
69622 Villeurbanne-Cedex , France
Received on Mon Jan 08 1996 - 00:00:00 CET

Original text of this message