debugger crashes program

[rbrooker]

debugging a package.
have a variable that i want to set a watch on.
takes a while to get to the variable.
set a breakpoint on the line prior to the variable and hit the run button.
while it is running, click the variable and choose 'Add variable to watches'.
CRASH!
program exits every time.
plsqldev : 5.1.2.682
os: winxp sp1
db: 8.1.7.2
client: 9.2.0

------------------
richard.brooker@vuw.ac.nz

 

[Marco Kalter]

This may be a Net 9.2 bug. Can you run the following query in SQL*Plus 9.2 from the same Oracle Home on the same database?

SQL> select * from all_tab_columns;

Let me know what happens.

------------------
Marco Kalter
Allround Automations

 

[rbrooker]

no problems.. came back with a tonne of rows as expected.

 

[Marco Kalter]

As a test, can you enable the "Force OCI7 on OCI8" preference and try again?

------------------
Marco Kalter
Allround Automations

 

[rbrooker]

done that, still get all rows back.

------------------
richard.brooker@vuw.ac.nz

 

[Marco Kalter]

Sorry, I meant to say:

As a test, can you enable the "Force OCI7 on OCI8" preference and try to debug this package again?

------------------
Marco Kalter
Allround Automations

 

[rbrooker]

ok, i have turned on the "Force OCI7 on OCI8" preference and tried again, started debugging, hit the green "run" button and then tried to add a variable to the watches, CRASH, again she goes splat.

Cheers,
Richard.

------------------
richard.brooker@vuw.ac.nz

 

[patch]

I've had this same problem. It only occurs when the program is running. If you put a breakpoint somewhere in the code and then start adding variables to watches, there is no problem.
Maybe this helps.
(and maybe this helps Marco in investigating this problem)

------------------
Check out: http://www.oracledeveloper.nl

 

[rbrooker]

I admit, this works for me too, but as the breakpoint was a way down the code and going to take a bit of time, i set the watch on the variable so i wouldnt have to watch it etc... viola, a crash.

Seeing as PLSQL Developer is such a great program, this should probably be ironed out as its kinda disconcerting to have a program totally disappear on you.

Cheers,
Richard.

------------------
richard.brooker@vuw.ac.nz

 

[lcbowen3]

I also have the same problem. If I add a watch variable to a debugging session while it is running (i.e. not stopped at a breakpoint), the program totally disappears -- no messages, no warnings, nada.

 

[Marco Kalter]

Hmm, that sounds like something we can fix...

------------------
Marco Kalter
Allround Automations