SOLVED: hide the path to oracle help when showing Oracle error

[Claus Pedersen]

In an SQL window, I write:

SELECT object_nam FROM user_objects

and I get the error:

ORA-00904: "OBJECT_NAM": invalid identifier
Help:https://docs.oracle.com/error-help/db/ora-00904/

Can we have an option so PLD does not show the "Help:" line, it clutters up the overview of the actual ORA error (and most of us probably already knows how to search online for Oracle errors).

 

[Marco Kalter]

I don't think this is a PL/SQL Developer feature. Perhaps you have installed a Plug-In that adds this text?

 

[patch]

This is a new feature of Oracle Database. They are working on making the error messages more useful. It’s a separate project but you will see the new messages starting with Oracle Database 23ai.

 

[Claus Pedersen]

Yes, I can see now that it is the instant client 23.5 that I am currently using that produces this extra message line. Client versions e.g. 19 or 21 does not show this extra line.
Thanks for your help, Marco and patch.

If this is the 'new black' for future Oracle clients, maybe it would be a good idea to prepare PLD for this already now. E.g. in the SQL window, the status line at the bottom of the screen is only designed to view a message that does not span more than one line.
If I try to e.g. insert a row in a table and I get a 2-line error message like the one above, it is shown vertically centered in the status line, so I can see only the bottom half of the first line and the top half of the second line. I have to double-click on the text to have the full text displayed in a pop-up message.
Please investigate and prepare PLD for this new Oracle behaviour.

 

[patch]

I am not a fan of this. If you decide to do this, then at least make it optional. I like to get as much information as possible, and with easy/common error messages my brain will filter out the rest ;-)

 

[Claus Pedersen]

+1 on this, the full 2-line error message should be displayed in the status bar, possibly with new-line character replaced by space so it can all be shown on the same status line. I was trying to say that PLD should be able to handle both 1-line error messages (as pre-23), 2-line error messages (as introduced in 23) and 3+ lines in the future.
If Oracle decides to return a more verbose error message, PLD should be able to display all lines.

 

[cassiusdrow]

I don't know if it works for the Windows client, but the Linux client documentation indicates that the error message URLs can be suppressed by setting the ORA_SUPPRESS_ERROR_URL environment variable to TRUE.
https://docs.oracle.com/en/database...cli/environment-variables-instant-client.html