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.

TortoiseSVN and SQL Developer

I'm using version 3 of Oracle SQL Developer and for my scripts I wanted to make use of a local subversion repository. I created a local repository and I added this repository inside SQL Developer. After checking out a working copy inside the folder c:\work, I wanted to check for modifications. The plug-in from SQL Developer does not always display the modified sources, so I thought of using TortoiseSVN.

When I use the "Check for modifications" from TortoiseSVN I get the following messages:
Error at entry 1 in entries for 'c:\work'
Entry contains non-canonical path 'file:///c:/reposdb'
Try a 'Cleanup'. If that doesn't work you need to do a fresh checkout.

I tried the Cleanup but it still gave the error. I checked the version of the subversion plug-in, which is based on SVNkit but that version can work with the version of the SVN-repository. After a long search I discovered that TortoiseSVN can not use a file based URL in which the drive letter does not start with a capital letter. I entered the URL file:///c:/reposdb inside the plug-in of SQL Developer and that works fine. TortoiseSVN gave the above error. After checking out a work folder from the URL file:///C:/reposdb everything works fine and both SQL Developer and TortoiseSVN can handle the changes.