Hi Mike, The problem is that it server-client channel and we were not able to read the file with xml parser. But finally got the solution, we are now converting the file into UTF-8 encoding using UTL_file and convert function.
Thanks for your inputs. Regards, Sonty On Apr 30, 7:23 pm, Michael Moore <michaeljmo...@gmail.com> wrote: > Hi Sonty, > The solution I referred you to will parse the XML into database structures > (tables) that support the Schema. I don't know about any specific problem > with WINDOWS-1252 encoding, but I assume the WebDAV protocol will take care > of it. > > Regards, > Mike > > > > > > On Fri, Apr 30, 2010 at 12:03 AM, sonty <saurabh.zen...@gmail.com> wrote: > > Hi Mike, > > > My problem is to be able to parse the XML file and import the > > information in the xml tags. > > And, the parsing is failing with the WINDOWS-1252 encoding. > > > Regards, > > Sonty > > On Apr 29, 10:56 pm, Michael Moore <michaeljmo...@gmail.com> wrote: > > > You can use webdav. Once you have it set up, it looks just like any > > folder > > > on your PC. Then you drop an XML document into that folder and it is > > > automatically sucked into your oracle database. > > > >http://download.oracle.com/docs/cd/B10500_01/appdev.920/a96620/xdb24p... > > > > Mike > > > > On Thu, Apr 29, 2010 at 2:33 AM, sonty <saurabh.zen...@gmail.com> wrote: > > > > Hi Guys, > > > > > Anyone has any idea about how we can import data in an xml file, > > > > encoded with WINDOWS-1252 encoding, into Oracle database. > > > > > Regards, > > > > Sonty > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "Oracle PL/SQL" group. > > > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > > > To unsubscribe from this group, send email to > > > > oracle-plsql-unsubscr...@googlegroups.com > > > > For more options, visit this group at > > > >http://groups.google.com/group/Oracle-PLSQL?hl=en > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "Oracle PL/SQL" group. > > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > > To unsubscribe from this group, send email to > > > oracle-plsql-unsubscr...@googlegroups.com > > > For more options, visit this group athttp:// > > groups.google.com/group/Oracle-PLSQL?hl=en > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/Oracle-PLSQL?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group > athttp://groups.google.com/group/Oracle-PLSQL?hl=en- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
