EXEC SQL WHENEVER SQLERROR GOTO DATABASE_CONNECT_ERR;
EXEC SQL WHENEVER NOT FOUND GOTO NOT_FOUND; EXEC SQL CONNECT :username IDENTIFIED BY :password;
CONNECT_ON:
EXEC SQL WHENEVER SQLERROR GOTO DATABASE_ERROR;
EXEC SQL WHENEVER NOT FOUND GOTO NOT_FOUND; EXEC SQL CONNECT :username IDENTIFIED BY :password;
CONNECT_ON:
EXEC SQL WHENEVER SQLERROR GOTO DATABASE_ERROR;
SQL PLUS 中需要有“;”才可以执行
但是在程序中传递的SQL语句解析的时候不是SQL PLUS,所以会有问题,你可以一个一个的命令时噫嘻
② EXEC SQL CONNECT 'user/pass@lnk'