#include<stdio.h>
#include</ora10gclnt/product/10.2.0/db_1/precomp/public/sqlca.h>

char userid[30] = "billing/dbname@passwd";

void sql_error();

int main()
{

int emp_id;
float raise_sal;

EXEC SQL WHENEVER SQLERROR do sql_error("Oracle error");

EXEC SQL CONNECT :userid;
printf("Connected.\n");

printf("\nEnter the EmpID:  ");
scanf("%d",emp_id);

printf("\nEnter the raise_sal:  ");
scanf("%f",raise_sal);


EXEC SQL EXECUTE
        BEGIN billing.RAISE_SALARY
        (:emp_id, :raise_sal);
        END;
END-EXEC;

EXEC SQL COMMIT WORK RELEASE;

return 0;
}