Recent content by Patrick Holmes

Thank you Jeff Kandt for figuring out why it was so confusing for me! Given that I never have used this feature (on-purpose), I have changed the key configuration to

Of course! Thanks! (I was away from IPC/TeamHealth and Oracle development for about two years, terminated after an acquisition, but recently brought back for some consulting. I still *love* this product. Every day it seems that I am reminded of or find one elegant feature or another in your...

I create files of SQL statements. I frequently accidentally type or which triggers the "Previous SQL" or "Next SQL" behavior. This constantly causes me to get confused and have to re-do work. I haven't figured out what exactly this does, but I always seem to have to redo some work. My question...

Here is an enhancement request for the "Compare User Objects" tool: It would be nice if you also compared dbms_scheduler jobs code. We do have code in some of our jobs (in the "Action" field). We changed code in a job in DevTest and forgot to deploy it to Production because the comparison tool...

Have you given any more thought about this request? The issue is enough of an annoyance and time-waster for me that I will pay you US$250 (in addition to our annual license fee) if you make this change. I expect that you don't normally assign priority to enhancement requests by having people...

I switched from using a 32-bit WinXP to using a 64-bit Win7 computer, yesterday. Everything I've used so far in PL/SQL Developer is working fine except: When I open the DBMS Scheduler tool and then click on the "Running Jobs", "Jobs" and "Chains" folders in the tool's tree ("Job Runs", "Running...

Thanks for your feedback. I think I've proved below that this is a bug. I know you don't have time to decipher my logic, but there are valid logical reasons why both "identical" assignments are necessary and if either one of them is missing, then the program will not function correctly. Here is...

P.S. I do also use the variable outside a loop you can't see. I will post the entire procedure here. If the forum strips out white space (which I think it does), you can just paste the procedure into a SQL window and use the [great!] "Edit/"PLSQL Beautifier" feature to make it readable again...

Thank you for taking the time to try to understand this. However, your response doesn't make sense to me because (a) I am using the value in an IF statement (which controls program logic) and (b) I am using the value as an argument in a procedure call which then does something very important...

Is there anything I can do to suppress an incorrect "Hint: value assigned to '' never used in" message? I'm trying to have a clean compile without warnings or errors, but I haven't been able to figure out how to suppress this one warning: "Hint Value assigned to 'v_prev_email' never used in...

That was it! I just didn't look hard enough. I had never used that feature before. I did search the manual but I first assumed it would be under preferences and then tried searching keywords but not the correct ones. Thanks! pat

On Win XP using version 10.0.5.1710, PL/SQL Developer "remembers" that I like to have my Objects Browser, File Browser and Connections tabs next to each other on the left-hand side. I don't think there is a Tools/Preference to control where those tools display. It just seems to remember...

Yes, what I was looking for is similar to COUNT_QUERY in Oracle Forms. The reason I asked is I have a new employee who's used TOAD for years. This is something that TOAD does apparently that PL/SQL Developer does not. So if the user right-clicks (over the query? or whichever query was run...

In other words, I want to know how many rows my query would return, without actually having to fetch and display all rows.

This is an enhancement request (unless you already have this feature but I couldn't find it): Let's say I run a query in a SQL window like "select count(*) from customers" and customers has 1,000 rows. The SQL window currently will show the first page of records, for example let's say 15 rows...