RESOLUTION #1
For "undeclared identifier '<variable_name>" error, Toad queries Oracle for all watches. If Oracle cannot watch a variable, Toad cannot watch it either. This effectively means that sometimes a complex datatype can be watched, and sometimes it cannot, depending on how Oracle interacts with the variable passed to it. If you receive ""undeclared identifier '<variable_name>'" that is all we can provide .There is an evaluate/modify button on the watches panel which will show you the contents of the watch and allow you to change it but only if Oracle allows it.
RESOLUTION #2
For "<Value Too Large>." error with very large varchar2 variables, here, we are asking Oracle for the value in which we simply get an error code (error code 33 (which isn't documented by Oracle) and an empty string returned. There is an evaluate/modify button on the watches panel which will show you the contents of the watch and allow you to change it, but only if Oracle allows it.
