Searching in source-code in Designer-repository

By | August 14th, 2009|Categories: Database|Tags: , , |

Especially for those who loves Designer, or who are forced to work with it.. 🙁 ,  2 scripts to search in de source-code of Designer (version

Script 1 can be used for searching text-strings in the source of pl/sql in Designer.
Script 2 can be used to search for the use of column-names in modules.

Run this as the owner of the repository.

With thanks to Timo Schijf,  developer.

Script1 : Searching in  pl-sql code

set feedback off
set pages 50000
set lines 300
set trimspool on
set verify off

break on modulename skip 1

select name “Workareas:”
from sdd_workareas

accept workarea_name default ‘GLOBAL SHARED WORKAREA’ char prompt ‘Name of Workarea [Default: GLOBAL SHARED WORKAREA] : ‘

accept searchstring char prompt ‘Text-string : ‘

jr_context.set_workarea (’&&workarea_name’);

select distinct name “Applications in this workarea:”
from ci_application_systems


The curious case of the left-handed mouse in webforms

By | July 6th, 2009|Categories: App. Server|Tags: , , , |

In OAS (, webforms, when using a left-handed mouse to expand a menu, the tree node is not expanding. No error is given.
For example, in ‘Material Workbench’ select the ‘+’ to expand ‘Organizations’ in the menu.
Left and right button does not do anything.
Also, the left handed users are having difficulties […]

Signing jar-files

By | April 29th, 2009|Categories: App. Server|Tags: , , |

A project is using Sferyx in Webforms, and the file HTMLEditorLight.jar is used. But 'copy and paste' from outside the form to the editor is not working. Cause: the jar-file need to be signed. To sign a jar-file the tools 'keytool' and 'jarsigner' is needed. But... why not use a script from e.g. webutil: With a few adjustments it's a quite common, usable script.

Internet Explorer crashes with Oracle forms / Jinitiator

By | April 3rd, 2009|Categories: App. Server|Tags: , , |

Problem: when running form modules using Internet Explorer and JInitiator 1.3.1.x, the browser window opens and crashes immediately before the applet starts. When using Mozilla Firefox, there’s no problem at all.

Several notes on Metalink about this:  602001.1, 430359.1, 550301.1
The issue does not occur when using Sun JRE version 1.4, 1.5 and 1.6.

This issue is first logged as JInitiator Bug 5643502 – INTERNET EXPLORER WITH WINDOWS LIVE TOOLBAR PLUG-IN CRASHES, but based on Sun Bug 4741238, the bug occurs in JRE version 1.3 (JInitiator is based on JRE 1.3) and the bug is fixed in JRE versions 1.4 and higher.

Solution according the notes
To avoid the crash,
(1) Use Sun JRE 1.4 and higher
– OR –
(2) Uninstall Windows Live Toolbar (or other software what you suspect is the cause)
– OR –
(3) Disable the toolbar’s associated Add-ons as the following:
1. Open Internet Explorer
2. From the menu open Tools -> Manage Add-ons -> Enable or Disable Add-ons
3. Select the following Add-ons and disable each of them by clicking the “Disable” button

– Windows Live Sign-In Helper
– Windows Live Toolbar
– Windows Live Toolbar Helper
– Windows Messenger
4. Restart Internet Explorer
– OR –
(4) Disable 3rd-party browser extensions as follows:
– From the browser menu Tools -> Internet Options -> Advanced
– Uncheck “Enable third-party browser extensions”

First I chose for the last option, the policy was changed by the Windows system administrators for all the clients in the network, and done.. But there were (un)expected side-affects, like a particular SSO-application could’nt be reached anymore. People didn’t appreciate this  😉


Sun JRE instead of Jinitiator with Forms and Webutil

By | January 26th, 2009|Categories: App. Server|Tags: , , , , |

Running Forms and Webutil with Sun Java 5.0.6 instead of Jinitiator.

And you know what:  it’s faster and has more functionality I’ve been told…
First you need the java-file. In this case: jre15006.exe.

Initially I found it hard to find on the site of Sun – didn’t even know the name of the file I was looking for…
Found it at but if you keep searching the Sun-website, you will find it here:

Then: where shall I put the file? The application server expects the file in /forms/jinitiator.
In forms.conf this is defined as:
AliasMatch ^/forms/jinitiator/(..*) “/software/oracle/middle/jinit/$1”

Next thing is the configuration in formsweb.cfg (at the end of this post is the configuration what worked for me,
but first some explanation, quoted from some notes):