How to retrieve sql log file in C# .net

See more:

C#

ASP.NET

Oracle

Hi,
I learnt that logging for an oralce SQL commands can be achieved using SPOOL Command, it is working fine if I execute the oracle sql scripts via SQL Plus or Toad, whereas the same logic is not working when i try to execute the sql script via C#.

On a high level my need is, a button click in a web page should execute a set of DML statements against Oracle DB and the log file should be created for the above action.

Please advise in executing the sql from C# and generating the log file for the same.

Trial Code:
-----------

Spool 'D:/MyFolder/MyLogFile.txt';

select sysdate from dual;

Spool off;

Thanks,
Priya