Debug problem

[ScottMattes]

why do I get the msgbox 'illegal value' error msg when trying to change the value of a variable during debug?

the definition is;
var_name varchar2( 205 );

the initial value is;
var_name := ' ';

during execution I right click on the variable while in scope and paste a new value into the edit control and press enter and get the msg.

 

[Marco Kalter]

Should work just fine. I don't assume you are entering quotes with the value?

 

[ScottMattes]

It was OP headspace (or lack of sleep).

Though I had done a select/copy operation the tool I was in didn't recognized the copy keystroke and the old, longer, version was still in the clipboard. When I pasted I didn't recognize that and when the error msg came up I was confused (more lack of sleep).

I also posted this (in a slightly different form) earlier, but somehow it isn't here (maybe a wide awake dream?).

Could the error msg bechanged to report the actual problem, or is there no more info available when this happens?

 

[Marco Kalter]

The Oracle Debug API provides an error number, which we translate to 'Illegal value'. Unfortunately there is no additional information to clarify the error.