Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems in Debug mode

252928Dec 31 2005 — edited Feb 1 2006
Hi,
I like Raptor a lot, but I can't seem to get the debugger working properly.

I created a tiny sample proc which I include below.

I set a breakpoint on the SELECT statement.

I hit the debug button and the Debug PL/SQL window appears, and so I click OK to debug.

The SELECT statement is highlighted so all looks good as I seem to have hit the breakpoint, but...

The mouse is stuck in hourglass mode and I've lost the debug menu as all entries are greyed out. I can't step through or watch items.

Once the debug process is complete the mouse still is in hourglass mode and I can't use it at all. The keyboard is still usable but the menus aren't in the right context either and I'm stuck. Occasionally, after some minutes, I can resume and end the session using the keyboard, but from there I just have to close down Raptor as the mouse is pretty much useless and I can't fully tab around all the sub-panes.

I can't see a similar issue in the forum or elsewhere for that matter. I get the same issue regardless of proc as I've tried others also.

This is what I ran:
CREATE OR REPLACE
PROCEDURE aatest IS
l_date DATE;
BEGIN
SELECT SYSDATE INTO l_date FROM DUAL;

DBMS_OUTPUT.PUT_LINE(TO_DATE(l_date, 'DD-MON-YY HH:MI:SS'));

END aatest;


Thanks in advance,
Garrett
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2006
Added on Dec 31 2005
5 comments
1,375 views