EntLib 4.1 DAB - Oracle update statement does not work

Topics: Data Access Application Block
Oct 20, 2011 at 5:46 AM


Please assist.  For some reason, Oracle update statements are not executing as expected.

Running select, insert, and invoking stored procedures run fine.  Only the update does not run.  Executing an update statement via my Oracle client application, it gets to update the fields accordingly, However running the same statement from EntLib 4.1 does not.

My last resort now is to use Oracle's client library but I want to avoid that if possible.



Oct 20, 2011 at 6:31 AM

Are you getting an error?  Or does the update seem to succeed (no error) but no rows are updated?  Also, what data provider are you using?



Oct 20, 2011 at 8:53 AM

Hi randy. 

You're right, there no errror and it seems to succeed just that no rows are updated.  Just using straightforward update command.

I'm using System.Data.OracleClient as the data provider. 

Very odd, isn't it?

Oct 20, 2011 at 11:42 AM

I think the issue is not isolated to EntLib.  I'm experiencing the same issue with the Oracle data provider.  Hmm, very odd.

Oct 20, 2011 at 1:41 PM

Yeah, consider this closed.  Someone messed up the synonyms of the custom tables -_- 

Thanks anyway, good to know EntLib is working as expected! :)