Pro C, CONNECT

Pro C, CONNECT

오라클에 접속하기 위해서 사용됨

EXEC SQL BEGIN DECLARE SECTION;

char *username = "scott";
char *password = "tiger";
char *dbname = "orcl";

char *connection_string = scott/tiger@orcl;

EXEC SQL END DECLARE SECTION;

EXEC SQL WHENEVER SQLERROR GOTO sql_error;

EXEC SQL CONNECT :username IDENTIFIED BY :password USING :dbname;
혹은 다음과 같이....
EXEC SQL CONNECT :connection_string;