Load XML into Database

Load xml file into store procedure to insert into table. Sample xml file: <?xml version='1.0' encoding='UTF-8' ?> <FctTypes> <reportType>SSS</reportType> <tradingDate>01-Jun-2017</tradingDate> <period>1</period> <Details> <facilityType>AAA</facilityType> <grossInjection>111.11</grossInjection> <netInjection>222.22</netInjection> </Details> <Details> <facilityType>BBB</facilityType> <grossInjection>333.33</grossInjection> <netInjection>555.55</netInjection> </Details> <Details> <facilityType>CCC</facilityType> <grossInjection>122.11</grossInjection> <netInjection>244.22</netInjection> </Details> </FctTypes> <FctTypes> <reportType>SSS</reportType> <tradingDate>01-Jun-2017</tradingDate> <period>2</period> <Details> <facilityType>AAA</facilityType> <grossInjection>111.11</grossInjection> <netInjection>222.22</netInjection> </Details> <Details> <facilityType>BBB</facilityType> <grossInjection>333.33</grossInjection> <netInjection>555.55</netInjection> </Details> <Details> <facilityType>CCC</facilityType> <grossInjection>122.11</grossInjection> <netInjection>244.22</netInjection> …

Continue reading Load XML into Database

Sending email through store procedure

Database email setup Double click 'Databse Mail' to start setup Create mail configuration select as below key in the profile name and click 'Add' key in email address and the server ip address add the SMTP email address and server ip address click 'Next' click 'Finish'   Store Procedure Parse in the profile to be …

Continue reading Sending email through store procedure