Recent content by Claus Pedersen

Thanks

I have the package code in a file: CREATE PACKAGE test IS END; / CREATE PACKAGE BODY test IS PROCEDURE tester IS BEGIN /* this is a comment with a slash at the beginning of the line: / */ NULL; END; END; / If I open this file in program window, I get the expected tabs for...

Thanks, I appreciate it

I have the code: CURSOR tester (param INT) IS SELECT * FROM dual WHERE dummy = param AND (SELECT 1 FROM dual WHERE dummy = param) = 1; When I place the cursor on the parameter param in line 1, the instances in lines 4 and 7 are highlighted. When I place...

Thanks, appreciate it

I have the code in e.g. a program window: tester := sys.standard.replace (srcstr => 'test', oldsub => ';', When I press F6 in the end of line two to get code completion, nothing happens. If I replace ';' by e.g. '?', it works as expected. Somehow, the parser...

As I wrote, this is not a biggie, there are more urgent fixes than this

I open PLD with no open windows. Title is: "user@database - PL/SQL Developer" I open package sys.standard. Title is: "user@database - PL/SQL Developer - View SYS.STANDARD" I close the editor again. The title is still "user@database - PL/SQL Developer - View SYS.STANDARD". I would have expected...

+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...

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...

In an SQL window, I write: SELECT object_nam FROM user_objects and I get the error: 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).

Thanks, appreciate it

I have the following code: CREATE PROCEDURE tester AS CURSOR my_cursor IS SELECT * FROM dual WHERE sys.standard.nvl (1,2) = 1; -- hyperlink does not work here BEGIN IF sys.standard.nvl (1,2) = 1 THEN -- hyperlink works here NULL; END IF; END; If I try to hyper-link to...

When I have the text in large data editor, it is not recognised as xml (and can not be parsed, formatted etc.) When I have the code <tester> </tester> it is recognised as xml and can be parsed and formatted in the large data editor When the xml is formatted by PLD, it is formatted into the...

Screenshot sent to support I can now partly reproduce: 1. Open PLD, it shows the logon dialog and I select SYS from Recent users. 2. I randomly view some packages, tables and make a select on user_source 3. The program window title always says "sys@xepdb1 as SYSDBA - PL/SQL Developer Beta" 4...