Running a CREATE OR REPLACE PACKAGE using OracleCommand
546960Jan 28 2008 — edited Jan 28 2008Hello:
We have a package that we would like to install in with an installer. So, we would like to run the SQL "CREATE OR REPLACE PACKAGE BLAH BLAH BLAH".
When we run the SQL on the database, it works fine. But when we try to run it from an OracleCommand, it fails to compile. We are reading the query from a file, so there is a potential problem there.
One interesting point is that if we open the non-compiling SQL on the database into an editor, it will compiler from then on. My guess is that there is some sort of invalid character sequence or something.
Any ideas?
Thanks,
Travis