When attempting to add a watch that contains a space in the Procedure Editor, for example "First Name", the watch window states:
Value
undeclared identifier '"First Name"'.
Oracle issue regarding spaces in variable names.
Since Toad is dependent on the Oracle DBMS_DEBUG API, we are limited by Oracle's own limitations. This is also an issue in SQL Developer.
WORKAROUND:
The spaces in variable names should ideally be underscores or another character separator, to eliminate the spaces.
A workaround is assigning a normal variable the value of the variable with spaces in the code for debugging and do a watch on the normal variable.
X := "variable with spaces";
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center