Re: Oracle Pro*C

In article <25Yr03M.ca9J00_at_amdahl.uts.amdahl.com>, rtan_at_polaris.utswrk (Rick Tan) writes:
>
> EXEC SQL BEGIN DECLARE SECTION;
> char name[20];

change this to

        VARCHAR name[20];

> EXEC SQL END DECLARE SECTION;
> .
> .
> strcpy(name,"Any Valid Name");

change this to

        strcpy(name.arr,"Any Valid Name");
        name.len = strlen(name.arr);



> 

>        EXEC SQL INSERT INTO mytable (name)  VALUES (:name);


>        EXEC SQL COMMIT WORK REPLACE;

Then, it should work.

Jennifer R. Amon            PHONE: (216) 775-6987   
Houck Computing Center        FAX: (216) 775-8573    
Oberlin College          
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu
_____________________________________________________________________