OracleScript cannot execute Procedures?
Posted: Fri 18 Jan 2013 09:53
Hi,
I made my first try with the OracleScript Class. The scripts I want to execute are a mixture of Inserts, Packages, procedures, types, ... . At the moment I read the scripts from simple txt-files into C#.NET and run them with script.Execute(). This works quite fine for nearly every case. But some errors occur, which do not occur if I run the scripts with sql Plus:
1.) "set define off" throws an error. If I remove it in C#, it runs without errors and the result looks okay in my database. Is this always the case???
2.) if i have a skript looking like the following "execute myprocedure(param1,param2);" and try to run it with script.Execute(), I get an Ora00900. What am I doing wrong here??
thanks in advance for answers!
Best regrads
Cyb
I made my first try with the OracleScript Class. The scripts I want to execute are a mixture of Inserts, Packages, procedures, types, ... . At the moment I read the scripts from simple txt-files into C#.NET and run them with script.Execute(). This works quite fine for nearly every case. But some errors occur, which do not occur if I run the scripts with sql Plus:
1.) "set define off" throws an error. If I remove it in C#, it runs without errors and the result looks okay in my database. Is this always the case???
2.) if i have a skript looking like the following "execute myprocedure(param1,param2);" and try to run it with script.Execute(), I get an Ora00900. What am I doing wrong here??
thanks in advance for answers!
Best regrads
Cyb