About vscode connection pl / sql database

[joesmith2016]

oracle数据库连接配置是在哪里改；我的目的是想直接在vscode里面实现查询oracle数据表，谢谢

[joesmith2016]

我已经配置了数据库连接 但是 执行sql还是提示 识别不了

[joesmith2016]

{
//测试环境
"plsql-language.connections": [
{
"ID": 2,
"active": true,
"database": "ORCLMESTEST",
"password": "mes2018",
"username": "mestest",
"name": "mestest@ORCLMESTEST"
}
],
"plsql-language.connection.activeInfos": "mestest/mes2018@ORCLMESTEST"
}

[zabel-xyz]

Please write in english, I can't understand what you want !

[joesmith2016]

i want user vscode to connect pl/sql ，then I can use vscode IDE querying oracle table data

Now I can‘t execute sql sentence：
SELECT * FROM t_Co_Emp_Desc where emp_no='120509010';
Please help me check setting.json file which paras error
the file: setting.json like this
{
//test enviroment
"plsql-language.connections": [
{
"ID": 2,
"active": true,
"database": "ORCLMESTEST",
"password": "mes2018",
"username": "mestest",
"name": "mestest@ORCLMESTEST"
}
],
"plsql-language.connection.activeInfos": "mestest/mes2018@ORCLMESTEST"
}

[zabel-xyz]

Now I can‘t execute sql sentence：

• Have you activate setting plsql-language.oracleConnection.enable: true ?
• Have you an error message ?
• Check also output / PLSQL
  
• Is the sql preview displayed ?
• What are you trying to do, what goes wrong ?

[joesmith2016]

1、execute the sql display this
tips:Code language not supported or defined.
2、the file: setting.json has setting the sql file like:
"plsql-language.connection.activeInfos": "mestest/mes2018@ORCLMESTEST",
"files.exclude": {
"**/.sql": true

[zabel-xyz]

How do you execute the sql display ? Are you sure to execute plsql command ?

Have you another extension installed like code-runner ?
Because I have found the message "Code language not supported or defined." in their code...If this is the case, contact the author of this extension...

You can try with extensions disabled, except this one to see if it's work...

[joesmith2016]

I user Ctrl + shift + p excute plsql-run current command，vscode show the information: No Oracle Server

[zabel-xyz]

Like I ask:

• Have you activate setting plsql-language.oracleConnection.enable: true ?

• Check also output / PLSQL
  

• What is your platform ?

You can also try to:

1. Close VSCode
2. Delete oracledb folder
   .vscode/extensions/xyz.plsql-language-version/server-oracle/node_modules/oracledb
3. Restart VSCode
4. Retry and Check output / PLSQL

Where to find vscode/extensions folder ?

• Windows %USERPROFILE%.vscode\extensions
• macOS ~/.vscode/extensions
• Linux ~/.vscode/extensions

[joesmith2016]

tips:{"error":"OracleDB is missing"}