ProC 連接Oracle代碼

一段簡單的ProC連接oracle的代碼

代碼如下:
int connectDb()
{
EXEC SQL BEGIN DECLARE SECTION;
char username[20];
char password[20];
char connect_string[20];
EXEC SQL END DECLARE SECTION;

strcpy(username,”lbc1″);
strcpy(password,”lbtux”);
strcpy(connect_string, “lbc1”);

EXEC SQL CONNECT :username IDENTIFIED BY :password USING :connect_string;
if ( sqlca.sqlcode {
return -1;
}
}