Pro*cダイナミックsql 2

#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlca.h>
void connect();
void sql_err();

void dynamic_sqltwo();

void main()
{
   EXEC SQL WHENEVER SQLERROR  DO sql_err();
   connect();
   dynamic_sqltwo();
   EXEC SQL COMMIT RELEASE;
}

void sql_err()
{
 // printf("%.*s
",sqlca.sqlerrm.sqlerrml,,sqlca.sqlerrm.sqlerrmc);
}

void connect()/*     -     ，   server*/
{
  EXEC SQL BEGIN DECLARE SECTION;
  VARCHAR oraCN[30];
  EXEC SQL END DECLARE SECTION;
  strcpy(oraCN.arr,"scott/Tiger@TEST_dist");
  EXEC SQL CONNECT :oraCN;
}

void dynamic_sqltwo()
{
    EXEC SQL BEGIN DECLARE SECTION;
    char name[10];
    int newsalary;
    char control;
    EXEC SQL END DECLARE SECTION;
    for(;;)
    {
       printf("intput employee name: ");
       gets(name);
       printf("input employee salary: ");
       scanf("%d",&newsalary);
       getchar();
       EXEC SQL PREPARE stat FROM 'UPDATE emp  SET sal=:a WHERE upper(ename)=upper(:b)';
       EXEC SQL EXECUTE stat USING :newsalary,:name;
       printf("continue? (Y/N)");
       scanf("%c",&control);
       getchar();
       if(control=='N'||control=='n') break;

    }
}