Re: help me!!! how can I insert data(pro*c)?

What you need to do is throw an NVL around the variable:

>> exec sql insert into a (b) values (NVL(:sql_dr_acc_type, ' ' ));

(there is a space between the two single quotes)

>kyutae lim wrote:
>
>> hi , there.
>>
>> I have a big problem in pro*c program.
>> this is sample program and table layout.
>> I found ora-1400 error.
>> hw can I insert '1 byte space charactor' in not null column?
>> -----------------------------------------------------
>> exec sql include sqlca.h;
>> typedef char char1;
>> EXEC SQL TYPE char1 IS char(1);
>> static char1 sql_dr_acc_type;
>> main()
>> {
>> char username[10], password[10];
>>
>> strcpy(username, "SCOTT");
>> strcpy(password, "TIGER");
>> exec sql connect :username identified by :password;
>> sql_dr_acc_type = ' ';
>> exec sql insert into a (b) values (:sql_dr_acc_type);
>> printf("code :%c:%d:\n", sql_dr_acc_type,sqlca.sqlcode);
>> exec sql commit;
>> }
>> --------------------------------------------------------
>> table layout
>> table a (b char(1) not null)
>> ^^^^^^
>
Received on Tue Jan 05 1999 - 10:26:02 CST