Using xml namespaces and attributes in test window causes ora-01036

[Claus Pedersen]

I have the following code in a test window:

DECLARE
  myXml xmltype;
BEGIN
  SELECT xmlelement ("ns:test",
           xmlattributes('http://www.w3.org/TR/html4/'
             AS "xmlns:ns"), 'tester')
  INTO   myXml
  FROM   dual;
END;

When executed, I get error ORA-01036: illegal variable name/number and PLD creates the bind variables test and ns. But I still can not execute the script.

Only if I remove the checkbox in Preferences -> Test Window -> Automatically scan bind variables before Execute
or if I add the following code to the test script, the test script will execute correctly:

:test := 1;
:ns:= 1;

Because of the colons, PLD incorrectly interprets the string literals in the calls to xmlelement and xmlattributes as bind variables.

Please correct this.

 

[Marco Kalter]

That is indeed not right. We'll fix it.

 

[Claus Pedersen]

@Marco, when is the fix planned?