Here is an example of the Pro*C program to connect to the Oracle Database.
Pro*C Program Example - Connect to Oracle Database
The below Pro*C program will connect to the Oracle database and will execute the stored procedure YourDBProc.
#include <stdio.h>
#include <string.h>
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20];
VARCHAR pwd[20];
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE SQLCA.H;
int sqlerror();
int main()
{
strcpy((char *)username.arr,"scott");
username.len = (short) strlen((char *)username.arr);
strcpy((char *)pwd.arr,"tiger");
pwd.len = (short) strlen((char *)pwd.arr);
EXEC SQL WHENEVER SQLERROR DO sqlerror();
EXEC SQL CONNECT :username IDENTIFIED BY :pwd;
EXEC SQL EXECUTE
BEGIN
YourDBProc;
END;
END-EXEC;
EXEC SQL COMMIT WORK RELEASE;
exit(0);
}
sqlerror()
{
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("\n% .70s \n", sqlca.sqlerrm.sqlerrmc);
EXEC SQL ROLLBACK WORK RELEASE;
exit(1);
}