Programming

#include<stdio.h>
#include<sqlca.h>
#include<oraca.h>
void main()
{
  EXEC SQL BEGIN DECLARE SECTION;
  int diff;
  EXEC SQL END DECLARE SECTION;
  EXEC SQL select trim(to_date('20101003','yyyymmdd')-to_Date('20091003','yyyymmdd')) into :diff from dual;
  printf("\n The difference value is %d \n",diff);
}

  EXEC SQL BEGIN DECLARE SECTION;
       int diff=0;
       short ind=0;
  EXEC SQL END DECLARE SECTION;
  EXEC SQL
    select whatever 
       into :diff :ind
    from mytable;
  if(sqlca.sqlcode < 0)
  {
        EXEC SQL ROLLBACK WORK RELEASE;
        fprintf(stderr, "Line: %d:  ORA-%05d\n", __LINE__, -1*sqlca.sqlcode);
        exit(1);
  }

oerr ora 1012