Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running a CREATE OR REPLACE PACKAGE using OracleCommand

546960Jan 28 2008 — edited Jan 28 2008
Hello:

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2008
Added on Jan 28 2008
2 comments
1,396 views