如何为JetBrains DataGrip配置Oracle PL/SQL系统包自动补全？

Hey there! Let's sort out that missing auto-completion for Oracle's DBMS system packages in your DataGrip 2017.3.7 setup. I've worked through similar quirks with older JetBrains IDE versions, so here's a step-by-step guide to get it working:

• Verify Database Connection Object Filtering

  1. Open the Database tool window, find your Oracle connection, right-click it and select Properties.
  2. Switch to the Options tab. In the Objects to include section, make sure either System objects is checked, or explicitly select the SYS/SYSTEM schemas (where most DBMS packages live).
  3. Click Apply and wait for DataGrip to re-synchronize the database objects—this might take a minute or two depending on your database size.

• Invalidate Caches & Restart
  Old or corrupted caches often break code completion. Here's how to reset them:

  1. Go to File > Invalidate Caches / Restart... (Windows/Linux) or DataGrip > Preferences > Invalidate Caches / Restart... (Mac).
  2. Choose Invalidate and Restart from the popup. Let the IDE fully restart—it'll rebuild its index and cache from scratch.

• Check Code Completion & SQL Dialect Settings

  1. Open File > Settings (Windows/Linux) or DataGrip > Preferences (Mac).
  2. Navigate to Languages & Frameworks > SQL Dialects > Oracle—ensure the SQL dialect is set to Oracle (mismatched dialects are a common hidden culprit for broken auto-completion).
  3. Head to Editor > General > Code Completion:
     • Confirm Enable auto popup in code is checked.
     • Adjust the Delay setting if needed (100ms is a good default to trigger suggestions quickly).

• Force IDE to Recognize DBMS Packages
  If the above steps don't work, try manually nudging the IDE:

  1. In your PL/SQL code, type a full DBMS package call (e.g., DBMS_OUTPUT.PUT_LINE('test');) and run it once. This helps the IDE pick up the package reference and add it to the completion list.
  2. Alternatively, in the Database tool window, find the SYS schema, locate the DBMS package you need (like DBMS_OUTPUT), right-click it and select Add to Favorites. This prioritizes the package for indexing and ensures it shows up in suggestions.

Keep in mind that DataGrip 2017.3.7 is an older version, so some modern auto-completion optimizations aren't available—but these steps should resolve the core issue with system package suggestions.

内容的提问来源于stack exchange，提问作者Tres