Recent content by Ed Holloman

Version 7.0.2.1076 Hi, I was doing some text parsing in PL/SQL and had an IF statement like this: IF substr(s1, 1, 1) != '(' THEN -- code ELSE -- code END IF; The problem is that after typing '(' in the IF statement, the syntax highlighter does not consider the quote...

PLSQL Dev Version 7.0.1.1066 (MBCS) Windows XP version 6.0 (build 2600) Service Pack 2 Hi, I've noticed an odd display problem with PLSQL Dev 7.0.1 when the window list is docked and there is a linked graphic in a web browser directly behind the window list. On the left I have the object...

Hi, I'd like to note that the features of the beautifier have improved markedly from 5.x to 6.x. I use it all the time and it's an extremely useful feature (version 6.0.5.931). I have a few requests (challenges) for the code beautifier, which I think the following examples illustrate. In...

Until that happens (release of 6.1), to the OP, if you don't mind dinking with the registry with regedit (or other editor), there is a registry key: HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\WindowList REG_DWORD named 'Count' having an initial decimal value of 8 (IIRC)...

Hi, I'd just like to add my $0.02 to this feature request. I recently overloaded some packaged programs to avoid breaking existing functionality. Short of doing a describe, test script or opening the package, there was no quick way to indicate which ones were overloaded to quickly check...

Hi, I've been using a number of package level constants/variables in the package body recently and have been missing this feature in 6.x. Looking at a coworker's version of 5.4.x, it appears that constants and variables appear in their own folder at the top of the package body contents. I...

Hello, When I execute the following statement in SQL*Plus, the error text and line number along with the error number/description are displayed: ======================== SQL> SELECT SUM(e.ename) 2 FROM scott.emp e 3 / SELECT SUM(e.ename) * ERROR at line 1: ORA-01722: invalid...

Sent debug.txt to support@allroundautomations.com. This problem appeared for me after first opening a test script with the first attempt to debug. After that, it appeared to work fine, until I reopened the test script again.

I've noticed the very same thing. I was using version 6.0.3.x (waiting for the sql window AutoSelect bug to be fixed in 6.0.4). I'll have to reinstall 6.0.3 again - have to have the debugger. Ed Holloman PL/SQL Developer Version 6.0.5.926 (MBCS) 01.21939 - 1 user license Windows XP...

Some additional information: This appears to happen often when I am connecting remotely to a database (from home, DSL), as opposed to connecting at work (T1 connection). It seems when there is more of a time delay in the connection process, the labels are lost/mislabeled. I haven't noticed this...

I second the second statement. I usually like to work with a set of scripts, test scripts, objects in a particular order, so I can find stuff more easily. I usually have a set of scripts that I paste into an open dialog, but doing this in PL/SQL Dev would be easier. I've experimented with the...

Version 6.0.3.893 (MBCS) Windows XP version 6.0 (build 2600) Service Pack 2 Hi, I've noticed that PL/SQL Dev will allow you to set a breakpoint pretty much anywhere. It's not until you attempt to debug a test script that it tells you that there are illegal breakpoints. It displays a dialog...

IIRC, I was getting this also in 6.0.4. I went back to 6.0.3 because of the bug introduced in 6.0.4 with the AutoSelect statement option in a sql window. Do you have a pre-release version (6.0.5??) to check this on?

Hi, I didn't see this posted (or overlooked it), but when I'm logged on to a database in PL/SQL Dev and change connections, the label is either lost or incorrectly displayed on the associated instance button in the task bar. For example, I use the same instance and logon to another session/data...