下面这两种方法可行:
EXEC SQL BEGIN DECLARE SECTION;
typedef struct
{
int a;
int b;
}abc;
EXEC SQL END DECLARE SECTION;
struct bbb
{
int a;
int b;
};
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[20];
VARCHAR password[20];
abc a;
struct bbb b;
EXEC SQL END DECLARE SECTION;
EXEC SQL INCLUDE sqlca;
int main()
{
strcpy(username.arr,"pcsp");
username.len=strlen(username.arr);
strcpy(password.arr,"pcsp");
password.len=strlen(password.arr);
EXEC SQL CONNECT:username IDENTIFIED BY:password;
printf("/nCOnnect to ORACLE as user;%s/n",username.arr);
return 0;
}