MySQL Forums
Forum List  »  Stored Procedures

load_file() returns null
Posted by: Hari Mohan
Date: December 05, 2017 04:56AM

Hi,

I am trying to load a xml file in stored procedure but it is always gives null.

Code I am writing here as below.

declare xml_content text
set xml_content = load_file(path);
select xml_content;

I am also trying to load same xml in MySQL 5.7 query analyser. But returns null.

select load_file('C:\Program Files\MySQLMySQL Server 5.7\data\mysql\Purchase\ProductsList.xml')

Please help me out and let me know if I am doing anything wrong here and also give its resolution.

Options: ReplyQuote


Subject
Views
Written By
Posted
load_file() returns null
8199
December 05, 2017 04:56AM
1921
December 05, 2017 10:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.