Re: Problem with XMLType transform

Ok, I duplicated your results when I do the create table, insert data, the have the transform in the select statement. However, even after changing the sytlesheet as you mentioned, I get my previous error when I perform the code below. Is the problem with the getstringval() call?

    xmlNode := xmlNode.transform(xsl_Ein_Gross);

    SELECT xmlNode.getstringval() AS ein_node     INTO strEinNode
    FROM dual;

    dbms_output.put_line(substr(strEinNode, 0, 255));
    dbms_output.put_line(substr(strEinNode, 255, 255));
    dbms_output.put_line(substr(strEinNode, 510, 255));
    dbms_output.put_line(substr(strEinNode, 765, 255));
    dbms_output.put_line(substr(strEinNode, 1020, 255));
    dbms_output.put_line(substr(strEinNode, 1275, 255));
    dbms_output.put_line(substr(strEinNode, 1530, 255));
    dbms_output.put_line(substr(strEinNode, 1785, 255));
    dbms_output.put_line(substr(strEinNode, 2040, 255));