missing bracket in pl/sql with xml

[jlloret]

Hi,

I have run the following PL/SQL program dealing with XML in Oracle Database 10g Enterprise Edition Release 10.1.0.2.0.

declare
documento XMLType;
plantilla XMLType;
result XMLType;
begin
documento:=xmltype(
'


Peter
Computer Science


');
plantilla := xmltype(
'
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
utput method="xml" indent="yes"/>


hi



');
result:=documento.transform(plantilla);
end;

The I get the error

ERROR en lÃ*nea 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00407: right square bracket missing in the XSL file
ORA-06512: at "SYS.XMLTYPE", line 168
ORA-06512: at line 27

When I try the XSLT stylesheet of the program in the XSLT Transformer

http://www.xmlme.com/XsltTransformer.aspx

it works fine

Any ideas about the reason of the error?

Greetings, George

[jlloret]

Hi again,

I do not know why but several fragments of my post are missing. I send again the message:

=====Resent message==========

I have run the following PL/SQL program dealing with XML in Oracle Database 10g Enterprise Edition Release 10.1.0.2.0.

declare
documento XMLType;
plantilla XMLType;
result XMLType;
begin
documento:=xmltype(
'


Peter
Computer Science


');
plantilla := xmltype(
'
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
utput method="xml" indent="yes"/>


hi



');
result:=documento.transform(plantilla);
end;

The I get the error

ERROR en lÃ*nea 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00407: right square bracket missing in the XSL file
ORA-06512: at "SYS.XMLTYPE", line 168
ORA-06512: at line 27

When I try the XSLT stylesheet of the program in the XSLT Transformer

http://www.xmlme.com/XsltTransformer.aspx

it works fine

Any ideas about the reason of the error?

Greetings, George