Recent content by Allen Marshall

I may not be doing this correctly, but I often need to just stop PLSQL Developer and do something else, then come back to it. It appears that this will demand I save everything in all windows before I can exit. In VS Code, I can just leave and I will more or less get back where I was on...

Upvote.... particularly the PROMPT statements that SQL*PLUS does not understand. Helpful when sending stuff to backward colleagues stuck with Stone Age tools....

Not a project. I would like PL/SQL Developer to just capture my active windows, even new and unsaved files, as a 'workspace' when I close the application, similar to the way Visual Studio Code does this. Have I missed a preference that will make it behave this way? Right now the only way I...

I have seen exactly the same thing. I have learned, somewhat unsuccessfully, to avoid clicking anything that will go ask Oracle for more information. Only helps a bit since there are lots of places where all this helpfulness is invoked, which by and large should be a good thing but not so much...

We are encountering a situation where certain folders in PL/SQL Developer are empty, such as Materialized Views, but we need to see the objects and at least View their contents for most users. The powers-that-be want to limit Edit access to most objects to DBAs only, but the DBAs support...

I have used all 3 of these products and PL/SQL Developer is the simplest and cleanest of the bunch to use. I can see where the UI could use a bit of freshening (themes, macro improvements, etc.) as mentioned in other threads but even so, I need it to stay consistent with its heritage. I can...

If PL/SQL Developer is terminated by the Task manager, it offers to restore the session insofar as that is possible on restart. However, that splash screen then becomes the 'icon' or mini-window for the application rather than the actual login pane. Just a minor annoyance... To reproduce...

thank you

It would be a huge help to be able to click on a bunch of tests in the Test Manager and disable/enable them all at once. The UI does not support this.

Is there any way to not have the test runner show the tests flashing on the screen while running? Just show maybe progress listing? Thank you.

Not clear on what 'failure' means in the test manager. Is it just a test of expected value versus returned value, or does coding and throwing an exception also turn the test red? Does it report the SQLCODE for the exception? There are certainly tests that should cause a proc/func to fail...

OK, confirmed. I must have tripped over my shoelaces. The only suggestion I might have is that the app require a distinct name for each test. So, funcXtest1 - inputs a,b,c, result 1 funcXtest2 - inputs d,e,f, result 2 funcXtest3 - inputs a,NULL,c, result EXCEPTION A button to duplicate a...

at the risk of droning on and on, each entry's description should be distinct, and, it should be possible to duplicate an entry in Test Manager and then tweak the inputs and modify the description. For consistency with other unit testing frameworks, (optional) Setup and Teardown test phases...

I may be missing the obvious, but I want to add the same test over and over to the test manager with a range of inputs and expected results. Do I have to create a separate variant test file for every one of these? I would like to see this in the test manager tests window - same TST file...

Is that possible? What's the process? (assuming Oracle 64 and 32 bit clients are in place already)...