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