Recent content by bcoulam

Left laptop in sleep mode over the New Year's weekend. This morning upon starting PSD, found that the Connections pane was open, which I don't use and had removed from the sidebar, and my custom toolbar configuration was gone, replaced by the default. Odd that, unless PSD updated itself with...

Marco, Can I beg of you to bump this enhancement request to ensure it gets into version 11? It really shouldn't be that time consuming to ensure the "Change Window to" options can be key-configurable like almost everything else in PSD. It's been far too long and the problem is still there...

Thanks Marco! I first tried just removing the value of the Monitor key. Didn't work. Then I removed the Monitor key. Didn't work. Then I removed all five keys, as you suggested. Finally when I bring up PSD, the splash, connection and main windows all appear on my home monitor.

I've been living with this for some time, then this morning asked myself why I'm living with it. Could not come up with a good answer. I have Win 7 Pro 64-bit. Lenovo W540, docked. Two Dell 23" monitors. Screen on my left is monitor #1. Screen on my right is monitor #2. I once made the mistake...

We're now two versions later and this still isn't fixed. I'm on PSD version 10.0.5.1710 I'm getting the exact same output when I call upon dbms_xplan.display_cursor, either without arguments, or with the sqlid parameter bypassed using named notation. According to the docs if sqlid isn't passed...

Marco, If I haven't requested this enhancement before, will do so now. I'm sure all your users would benefit from it. I'd like to be able to prompt the user for a value, then use that value in a query variable in the same template. For example, I have a unit testing script that tests new view...

Marco, While you're adding to the enhancement list, here's one that bugged me for years which should be really easy to fix. I'm frequently finding an object in the browser (table, column, trigger, constraint, etc.), then right-click and select "Copy comma separated" since a simple "Copy Name"...

In the SQL window one can use Ctrl+G to jump to a line number, and the current line number location of the cursor is displayed in the bottom left corner of the window. This is also true of the Program window. But the Command window does not show the current line number in the lower left corner...

When disconnected from a DB, I used to be able to work on code just fine. New in v9, it seems to always be looking for metadata in the unavailable data dictionary. It does this about every 20 seconds or so, usually after typing a new table name, column name or alias. It will spin for about 5 to...

Urg, I shouldn't have so rash, thinking the problem was with a later version of PSD. When I downgraded my client, pointing PSD to my 11.1 InstantClient oci.dll, the problem went away. Don't have the energy to start an SR with Oracle. Hopefully someone's already found this one and got a fix...

I don't believe we've come to a conclusion on this error yet. I have PL/SQL Developer 8.0.3. My co-workers have TOAD 10.X and PL/SQL Developer 8.0.0. We recently upgraded our Dev database from 10.2.0.4 to 10.2.0.5. All of a sudden, when I query dba_scheduler_jobs or open the Schedule | Jobs node...

So the Command window in PSD emulates SQL*Plus really well. I only have to bring up SQL*Plus maybe twice a year now. However, there seems to be a bug in how PSD emulates the SET SERVEROUTPUT ON and SIZE command. On 9i, I got in the habit of always specifying the size of the buffer: SET...

We are using Oracle's queueing facilities. Part of the setup involves granting another schema rights to dequeue from the schema that owns the queue. This is done through the dbms_aqadm.grant_queue_privilege routine. When that is successful, one can see the privilege in dba_tab_privs. If you...

Marco, I thought I'd asked for this years ago, but seeing how it's not in v8 yet, perhaps I forgot. When using Find Database Objects, the window gives the options to look inside the source code of every database object except DBMS jobs. I'm not yet familiar with 10g's Scheduler, but if jobs in...

Although log4plsql has been around a while and provides lots of output options, I found it overblown, and the last time I looked, not terribly well maintained. The instrumentation features of the open source PL/SQL Starter Framework make it very easy to use and dynamic. By easy to use, I mean...