How to run .sql file from Oracle Procedure.
I have set of complex queries in a .sql file and I need to run it
from Oracle procedure. That SQL file also creates a spool file of output on the specified drive.
How can I use something like EXECUTE_IMMEDIATE here. I am using Oracle 8.0.1 .. Therefore output is not supporting REFCURSOR. Is there any way that I can get the output of these queries in file from a Stored Procedure.
I need to do that way because I need to call this procedure from VB.
Your quick help will be appreciated.