Oracle Observations

May 10, 2011

Using default oracle forms icons and graphics.

Filed under: Oracle forms — bigdaveroberts @ 4:30 pm

One suggestion on tuning oracle forms applications included in the AMIS blog:  http://technology.amis.nl/blog/10141/oracle-forms-10g-tuning-tips was to use the icons included in the Oracle forms java runtime.

While I don’t imagine saving a few thousand bytes of data downloaded to the client PC will substantively improve performance, how do we use these free icons?

After a little experimentation it is apparent that all we need to do is to include a UNIX style (that is with a forward slash and case sensitive directory/file names) relative path.

For convenience the most useful icons are listed here:

oracle/forms/icons/badimage.gif  
oracle/forms/icons/canqry.gif  
oracle/ewt/laf/oracle/images/caution.gif  
oracle/ewt/laf/generic/images/caution.gif  
oracle/ewt/laf/oracle/images/colorChoice.gif  
oracle/forms/icons/copy.gif  
oracle/forms/icons/cut.gif  
oracle/forms/icons/delrec.gif  
oracle/forms/icons/ellipsis.gif  
oracle/forms/icons/entqry.gif  
oracle/forms/icons/exeqry.gif  
oracle/forms/icons/exit.gif  
oracle/ewt/laf/oracle/images/folder.gif  
oracle/forms/icons/frame.gif  
oracle/forms/icons/help.gif  
oracle/forms/icons/insrec.gif  
oracle/forms/icons/lockrec.gif  
oracle/ewt/laf/generic/images/multiItemDrag.gif  
oracle/ewt/laf/oracle/images/note.gif  
oracle/ewt/laf/generic/images/note.gif  
oracle/forms/icons/nxtblk.gif  
oracle/forms/icons/nxtrec.gif  
oracle/forms/icons/paste.gif  
oracle/forms/icons/print.gif  
oracle/forms/icons/prvblk.gif  
oracle/forms/icons/prvrec.gif  
oracle/forms/icons/pset.gif  
oracle/forms/icons/save.gif  
oracle/ewt/laf/oracle/images/stop.gif  
oracle/ewt/laf/generic/images/stop.gif  

 

And while it might only have a marginal effect on performance, it should be a good first step to establishing a consistent look and feel!

Interpreting ora-305500

Filed under: OLE,Oracle forms,PL/SQL — bigdaveroberts @ 9:28 am

The message returned from the sqlerrm function having encountered an ORA-305500 error consists of the slightly cryptic:

non-ORACLE exception.

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:
http://support.microsoft.com/kb/122957

Blog at WordPress.com.