Hi. I'm trying to debug a trigger in Oracle 9.2.
I'm using the latest plsql developer.
When I step into the trigger, I notice that I can't get the value of :new.columnname .. it says the value is "(Debug session busy)".
Any hints on how to deal with this?
To be exact I have this statement:
if inserting or updating then
if ((nvl
new.col1, '-') != 'desiredvalue1') or
(nvlnew.col2, '-') != 'desiredvalue2'))
then
return
end if;
:
:
I'm using the latest plsql developer.
When I step into the trigger, I notice that I can't get the value of :new.columnname .. it says the value is "(Debug session busy)".
Any hints on how to deal with this?
To be exact I have this statement:
if inserting or updating then
if ((nvl
new.col1, '-') != 'desiredvalue1') or(nvl
new.col2, '-') != 'desiredvalue2'))then
return
end if;
:
:
ld value is requested, it hangs. We will disable this in the next patch release. You will not see the value, but at least it won't hang.
