Discussion on:

Read an XML file from SQL Server

Is this something which can be done in an Oracle RDBMS?

Hi!

I just want to ask. Instead of loading the XML file, is there a way wherein the stored procedure can directly access the contents of the file? Because I'm worried that frequent loading of the XML file (everytime a user needs some data) may affect the server's performance. What I'm currently thinking of right now is to load the contents of the file to the database. But the problem is, the contents of the XML file changes daily and I'm not sure if we are allowed to use this solution.

Can anyone advise?

Thank you very much.

I want to read the contents of an XML File which is stored in the memory and not in the Database. If i can read the data from the XML file , then only i have to insert that data accordingly into the database.

Please help !!!!!!!!
Thanks in Advance

For SQL 2005, you can also do this:

DECLARE @FileName varchar(255)
DECLARE @ExecCmd VARCHAR(255)
DECLARE @FileContents VARCHAR(max)
DECLARE @TempXML TABLE (ThisLine varchar(255))

SET @FileName = 'C:\test.xml'
SET @ExecCmd = 'type ' + @FileName
SET @FileContents = ''

INSERT INTO @TempXML EXEC master.dbo.xp_cmdshell @ExecCmd
SELECT @FileContents = @FileContents + ISNULL(ThisLine, '') FROM @TempXml
SELECT CONVERT(xml, @FileContents) as FileContents

good bless you!
it works fine.

Hello,

We may insert XML data through .Net application into the database via the usage of stored procedure. The whole program has
been illustrated in the best way in this link. You may visit it...

http://www.visiontechno.net/studymats/xmlinsertion.html