Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Index was outside the bounds of the array.

User_RMW5FOct 12 2022

Hello,
on some databases when we try to select from a table we receive following
error message: Index was outside the bounds of the array.


SQL> select * from mul; --- is a table in our database

Index was outside the bounds of the array.

Oracle extension: Latest
VS CODE Version
Version: 1.72.1 (user setup)
Commit: 129500ee4c8ab7263461ffe327268ba56b9f210d
Date: 2022-10-10T17:22:48.346Z
Electron: 19.0.17
Chromium: 102.0.5005.167
Node.js: 16.14.2
V8: 10.2.154.15-electron.0
OS: Windows_NT x64 10.0.22000
Sandboxed: No

Comments

This sounds like a bug.
Could you please do a describe on "mul" and provide the results. If describe doesn't work in VS Code, please try sql Plus or SQLCL.
eg "describe mul"
Next, can you please email me the logs:

  1. Go to Visual Studio Code Settings for Oracle Developer Tools for VS Code and
    a) Check "Enable Logging"
    b) Set Logging Level to "Information"
  2. Close and reopen Visual Studio Code
  3. Reproduce the issue
  4. From cmd palette (F1), enter "Developer: Open Extension Logs Folder". It will open file explorer. Look in "Oracle.oracledevtools" folder.
  5. close Visu.al Studio Code
  6. After closing Visual Studio Code please email me all files shown in the "Oracle.oracledevtools" folder at email address: christianDOTshayAToracleDOTcom
1 - 1

Post Details

Added on Oct 12 2022
1 comment
1,052 views