Watches and Toad Oracle Debugger

Toad for Oracle
1

Hello,

I'm trying to debug a procedure that has the following type declared:

TYPE tab IS TABLE OF mytable%ROWTYPE;

m_tab tab := tab ();

When I add m_tab.id to the watch it does not recognise it as a variable.
I tried m_tab(i).id where i is loop variable and I tried m_tab(3).id as well.

Can you please tell me how to deal with such variable ?
You help is greatly appreciated.

Thank you

2

Toad uses the DBMS debugger provided by Oracle for getting watch information. In many cases, the debugger simply doesn’t return a value for us to display due to the “complexity” of the variable in place. In cases like this, you can create a simple scalar type and assign the complex variable to it and Toad will be able to perform a watch on it.

for example:
x := m_tab(i).id;