Debugging and Variable goes to (Not Variable) content message

Poulos

Member
I'm buidling a Sql statment with mulitple variables that get combined into a Final variable.

When Debugging, I can see the contains of each of the variables, But the Final Variable says "Not a Variable".

The procedure works fine, I was just unable to review the contains of the final variable without first putting it to dbms output.

When testing were the Final sql goes from showing data to not a variable was about 1000+ characters (my variable is about 1200).

Is this a PL/Developer or Oracle debugger issue?
 
The Oracle Debugger has a limitation of 1000 bytes for variable values. Larger values cannot be displayed unfortunately.
 
Back
Top