Recent content by Mic R. W. Buchanan

I am having a very frustrating issue with collections. I am assigning values in my package but because of the way that the formatter does collections I cannot see the value while debugging. The beautifier puts it as: l_tab(l_cnt).v_cell_phone := l_tab(l_cnt) .v_bnr_cell_phone...

Does this tool provide an sql optimizer? I DETEST Toad, but am forced to use it because I can't find anything in PL/SQL Developer. I can only do so much with an explain plan.

In the preferences>SQL Window, what number do you have in the Records Per Page? Do you have it Automatically determined, or Fixed...or All?

I inadvertently un-docked my tools from the left side of the PL/SQL Developer window and I cannot get it to reconnect. It only wants to connect at the top. Any hints? Tips? Yes I realize this is minor to some, but it slows me down considerably!!! Mic R. W. Buchanan University of Oklahoma - IT

Lucida Console on the editor fixes that issue.

When I use beautifier, what font works best. It doesn't look like things line up in the editor but when I paste them here they line up. I have tried Times New Roman, Tahoma, Verdana. I really don't care what font I use as long as it lines up. It is very strange, I haven't had this problem...

I am having a very strange issue. When I use the debugger, the line being executed is not the line being highlighted. This makes it very difficult to really see what is going on. Has anyone else noticed this, or is there a fix for it?

I get this problem and the no trace file can be found. I have uninstalled the application, since it has worked rather successfully previously. We reloaded the debug packages and it made no difference. Any other ideas?

The debug information is in my package, but I am having the same difficulty. Any ideas??