How Can I execute pl/sql query??

[Vanamaindia]

set markup HTML on spool index.html SELECT * FROM pap_in_indexmaster; spool off set markup HTML off I want to execute this script, as it is, so that it does the spool command as it has been scripted to do. I want to execute this script in asp.net.... How Can I do that?? or any alternative to display the query result in HTML table view in HTML page..??

[andyharman]

The spool command (and I think the set commands too) are specific to the Oracle SQL*Plus tool. If you want to replicate this in ASP.NET then you will have to create a DataReader object and convert the results into HTML within your ASP.Net code. Regards Andy