The message returned from the sqlerrm function having encountered an ORA-305500 error consists of the slightly cryptic:
However, while I have no documented confirmation of this opinion, the fact that this corresponds with the pre-defined oracle forms exception: OLE2.OLE_ERROR defined in the Oracle forms OLE2 package, then, unless this error is thrown in another oracle product, then I would suggest that it is safe to assume that what has been encountered is an OLE2 error!
And the simplest interpretation of the error is, the developer has ignored Oracles advice on handling OLE errors!
In the Oracle Forms documentation there is a clear example on how this error should be handled and what further information should be available.
Thus it is my recommendation for anyone who encounters this error and who has the source code available for their application to get hold of the appropriate Oracle documentation: Oracle Forms Developer and Oracle Reports developer – Common built in packages – release 6i document: A73152_01.pdf currently available here: http://download.oracle.com/otn_hosted_doc/forms/forms/A73152_01.pdf
In the documentation (the best example is included in the OLE2.Last_Exception section) you will there get an explanation as to how Oracle recommends you handle this type of error:
— OLE errors are formatted as 32 bit unsigned integers and
— returned as Oracle NUMBERS. We want to extract only the
— error code, which is contained in the lowest 16 bits.
— We must first strip off the top [severity] bit, if it
— exists. Then, we must translate the error to an
— INTEGER or BINARY INTEGER and extract the error code.
Unfortunately, most people don’t follow the above advice, and if you search on Google for ‘OLE error 1004′ you will receive less hits than if you search for the original hex error number : 800A03EC.
So the advice is: If you are using the OLE2 package, make sure you add an error handler for OLE2.OLE_ERROR exception, then in the exception handler, make a call to OLE2.LAST_EXCEPTION to get the actual error number and then use the full error number in the error message rather than bothering to strip off the severity bit, etc.
In terms of actually interpreting the error, If you have a windows C compiler, you should have access to a copy of the WinError.h file where all the windows error messages are listed.
Look for the section beginning:
// Error definitions follow
// Codes 0x4000-0x40ff are reserved for OLE
// Error codes
Alternatively, if you don’t have access to this file, then you can download the file OLE error decoding tools from Microsoft support that lists most of the OLE errors and a very brief interpretation: