SQL PLUS COMMAN .SQL FILE .NET

Jul 22 2004 11:35 AM
I have a lot of *.sql files that have sql scripts in them. Some of these files are consisting of scripts that call other sql files using the @filename option. I am using oracle and the files are made to be run in SQL Plus(the @filename). I am wondering if there is a way in .NET to use these files. As of right now I am reading the files and executing them query by query using the semi colon as a delimter. So really I am looking for a way that .net can use the @filename option to load sql files. All help appreciated.

Answers (2)