By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

C# and Oracle Problem

P: n/a
The database team just patched the Oracle database with the latest and
greatest security patch. Since they patched it, my application has not been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0:PLS:00907: cannot load library unit PKG_PRODUCT
(referenced by )" along with "ORA-04068: existing state of packages has been
discarded" though the packages have not been changed in serveral months. We
have tried recompiling them just in case. The application has worked till the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the database
does bring us back up, but only temporarily. The periods of us being up have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are having
problems (they are java), but my application is a lot more database reliant.
I created a test application that uses a stored procedure and inline SQL and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas?
Jul 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Susan" <Su***@discussions.microsoft.comwrote in message
news:2F**********************************@microsof t.com...
The database team just patched the Oracle database with the latest and
greatest security patch. Since they patched it, my application has not
been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the
database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0:PLS:00907: cannot load library unit
PKG_PRODUCT
(referenced by )" along with "ORA-04068: existing state of packages has
been
discarded" though the packages have not been changed in serveral months.
We
have tried recompiling them just in case. The application has worked till
the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the
database
does bring us back up, but only temporarily. The periods of us being up
have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but
we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but
am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are
having
problems (they are java), but my application is a lot more database
reliant.
I created a test application that uses a stored procedure and inline SQL
and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas?
http://www.google.com/search?hl=en&q...=Google+Search

Jul 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.