Oracle Forms and Jasper Reports

I uploaded my demo to embed the Jasper Reports viewer inside Oracle Forms.

You can find the sources at: http://sites.google.com/site/oraont/jasperreports

Oracle Forms and JasperViewer continues

My first efforts of embedding the JasperViewer inside Oracle Forms look promising. I based a report on the HR schema and I can now run the reports with different parameters. The java code still has to many hard coded entries, so I still have to do some work on the code.

The images inside the report are now based on an URL which makes the report much more easier to deploy. I first deployed the report inside a jar, but I had to know where the images where. Now I can call the report through an URL and the report then also displays the images.

Jasper Report Viewer inside Oracle Forms

I'm trying to add the Jasper Report Viewer inside Oracle Forms . It now just displays one predefined report. 

Updated the Enhanced HTML Browser Bean

I've updated the Enhanced HTML Browser. I've added the getUrl method for getting the current URL of the browser and the execJS method for executing javascript 


For the code and the form look at the following url: http://sites.google.com/site/oraont/ehb.

Oracle Application Server version number

How to determine the exact version number of the Oracle Application Server (OAS).

On the Application Server you can find a file named ias.properties in the folder ORACLE_HOME/config. In this file there in an entry (Version) containing the version number of the Application Server.  This file is usually updated even if the application server has been patched. I patched an installation of an Oracle Forms/Reports server and after installing patchset the version number is 10.1.2.2.0 instead of 10.1.2.0.2

Oracle Forms, Headstart and error messages

The moment your Form logs into the Oracle Database and an error occurs, for example when your password has been expired, it is no longer possible to retrieve the error from the database. With older version of the database it still worked and the Headstart error message could be retreived. The 10gR2  database has become more secure and when the error can not be retrieved it will result in a FRM-92xxx error.

I changed the on-error trigger in the template(qms65tpl) by adding the following code

ON-ERROR
-- ORA-28001 - account expired
-- ORA-01017 - invalid username/password
-- ORA-00988 - missing or invalid password
-- FRM-92100 - passwords do not match
begin
  if (ERROR_TYPE = 'ORA' and to_char(ERROR_CODE) = '28001')
    or (ERROR_TYPE = 'ORA' and to_char(ERROR_CODE) = '1017')
    or (ERROR_TYPE = 'ORA' and to_char(ERROR_CODE) = '988' )
    or (ERROR_TYPE = 'FRM' and to_char(ERROR_CODE) = '92110')
  then
    message (ERROR_TYPE||'-'||to_char(ERROR_CODE)||': '||ERROR_TEXT);
  else
    qms$event_form('ON-ERROR');
  end if;
end;

Playing around with DDE inside Oracle Forms

When Oracle changed from client/server to WebForms the DDE functionality inside Oracle Forms moved from the client/server to the application server. So when using DDE inside Oracle Forms it called the applications on the application server.

Now I'm playing with a java jar which makes DDE at the client side possible. I can already make a connection with excel and write some data inside the cells and give a command to close the excel sheet.