Hi,
there is problem with quoted names of identifiers with with a colon inside used in Test Window. I prepared a simple example, but in fact I found this error when working with xml functions with this type of identifiers.
declare
"i:i" NUMBER := 1;
begin
dbms_output.put_line( "i:i" );
end;
The text parser adds :i to the list of bind variables and the run ends with ORA-01036: illegal variable name/number
Executing of this example in SQL Window runs correctly.
Pavel
there is problem with quoted names of identifiers with with a colon inside used in Test Window. I prepared a simple example, but in fact I found this error when working with xml functions with this type of identifiers.
declare
"i:i" NUMBER := 1;
begin
dbms_output.put_line( "i:i" );
end;
The text parser adds :i to the list of bind variables and the run ends with ORA-01036: illegal variable name/number
Executing of this example in SQL Window runs correctly.
Pavel
