1.在PL/SQL写关键字,出现提示,敲回车,空格后,弹出SQL Assistant - Connect to Oracle.
2.配置好连接,再点击Connect,右下角出现提示
3.提示内容如下:
Execute: OCI Error (2003): OCIStmtExecute ORA-02003: invalid USERENV parameter; SELECT SYS_CONTEXT('USERENV','SERVER_HOST') || '\' || SYS_CONTEXT('USERENV','DB_NAME'), SYS_CONTEXT('USERENV','SESSION_USER'), 'noDB', SYS_CONTEXT('USERENV','CURRENT_SCHEMA') FROM DUAL
4.把语句拿出来,在数据库执行,发现这里报错了( SYS_CONTEXT('USERENV','SERVER_HOST') )。
5.暂时不知道怎么搞,只能先暂停智能提示了。
- OCIStmtExecute Assistant parameter Execute invalidocistmtexecute assistant parameter execute parameter allowed invalid method ocistmtexecute assistant quot assistant associate deputy assistant数据data assistant 8266 home esp unavailable assistant currently location assistant language visual studio execute