Skip to Main Content

SQL Developer

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.

Auto Complete no longer works for user procedures and packages, and for schema with character "_"

Carlos Salheb JrJun 12 2024 — edited Jun 12 2024

I've noticed SQL Developer 23.1.1.345 has been a differente behaviour for some auto complete words.

For user procedures, functions and packages, auto complete hasn't been working any more. For exemple, i have a lot of procedures in schema called DA starting with “stp_” and if i type “exec DA.stp” or “exec DA.stp_” and ctrl+space, the auto complete doesn't show those procedures existing in that schema, but for system shemas it has been working normally, such as “exec dbms_sqltune.create_”. The same happens with packages and functions.

Also, the auto complete doesn't work for schema with character “_”. For exemple, if i type “select * from AD_” or “select * from AD” and ctrl+space, it doesn't work. I think there is something to do with the character “_”, because the command “select * from si_inf” doesn't work too and the schema si_informtn_schema is an internal schema. Schemas without “_” has been working normarlly.

Both these behaviours were worked in previous SQL Developer version 21.2.1.204.

This post has been answered by thatJeffSmith-Oracle on Jun 14 2024
Jump to Answer
Comments
Post Details
Added on Jun 12 2024
8 comments
624 views