load_file() returns null

[Hari Mohan]

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.