oo4o 2.2.03 vs. oo4o 2.3 : Error Handling

Some bugs in error handling appear to have crept into oo4o version 2.3 for Oracle 7.3.x, and version 2.2.03 seems more robust on this front.

Example: try updating or inserting records while logged in as a user to whom only select rights have been granted on the underlying table. In 2.2.03, you get a trappable VB error from which you can parse out the ORA-xxxxx error number. In 2.3 there's no VB error, but instead an oradc error (#28003) which is trappable only in the Error event of the datacontrol, followed by an Oracle error message indicating insufficient privileges. This error #28003 is also the error you get if you violate a uniqueness constraint, so it seems to be a catch-all.

Tim Received on Fri Sep 04 1998 - 00:00:00 CEST