Stuart, I'm not at all a streams guy, but I'm pretty sure you left out some basic info that Kirti (or someone else who knows about streams) will want to know.... Platform, O/S, O/S version, Oracle version?? -Mark -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxx www.proquest.com www.csa.com ProQuest...Start here. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stuart Blackburn Sent: Friday, December 19, 2008 10:35 AM Cc: oracle-l@xxxxxxxxxxxxx Subject: Converting XML Format LCR's Has anyone ever had success using the SYS.DBMS_STREAMS.convert_xml_to_lcr() function? I get an "ORA-19030 - Method invalid for non-schema based XML Documents" error every time. Even during testing when I run a SYS.DBMS_STREAMS.CONVERT_LCR_TO_XML() function, enqueue the resulting message and then immediately after I dequeue that same message and run a SYS.DBMS_STREAMS.convert_xml_to_lcr() I still get the error. I know there's nothing wrong with the xml format because I haven't modified it in this process. Thanks. Stuart -- //www.freelists.org/webpage/oracle-l