search

zabel-xyz / plsql-language

plsql-language for vscode
MIT License
79 stars 29 forks source link

About vscode connection pl / sql database #77

Open joesmith2016 opened 5 years ago

joesmith2016 commented 5 years ago

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

joesmith2016 commented 5 years ago

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

joesmith2016 commented 5 years ago

{ //测试环境 "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 commented 5 years ago

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

joesmith2016 commented 5 years ago

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 commented 5 years ago

Now I can‘t execute sql sentence：

joesmith2016 commented 5 years ago

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 commented 5 years ago

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

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 commented 5 years ago

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

zabel-xyz commented 5 years ago

Like I ask:

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 ?

joesmith2016 commented 5 years ago

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