Did You Know? -- August 2000

By Hervé Deschamps, Oracle Corporation.



Palm Emulator

You can get one at: http://www.palmos.com/dev/tech/tools/emulator/
You will also need to download a ROM file. You can get one after you submit an application (a bit tedious).
And you will also need a Palm emulator skin (for graphical display of the Palm). They really don't want to make this simple.

MS-DOS on Windows NT

In the command window there is a quick way to copy and paste without using the menu from the window bar. You can select text with the mouse, then right click your mouse. This copies your selection in the buffer. If you right click again, your selection will be pasted where the cursor is in MS-DOS. You can also paste the text in any other window like Notepad (^V) or SQL*Plus (^Ins). You can also copy text from any source and paste it in MS-DOS with just a right-click. For all this to work you need to setup your MS-DOS windows to Quick Edit Mode: right click on the window bar, select properties, check quick edit mode. While you are at it choose tab layout, set the buffer size height to 500 and the window height to 40 and you will get a nice scrolling MS-DOS window. Click OK, select "Modify shortcut which started this window" et Voila!

NT supports environment variables up to a length of 65520 bytes (64K-16), it depends on the application program what will happen if such a long variable is read. Some products (commonly old MS-DOS progs) support only 128 or 256 bytes, some of them crash with a string too long, others cut off ... Try to limit your Classpath to ~1000 bytes for the Java VM. Otherwise some older VM versions have problems. And check that the content of the classpath-variable is in the correct format!!


Expectation setting: -- You guys need to know this.

 WARNING: The Win32 release of Apache should still
   be considered beta quality code. It does not meet
   the normal standards of stability and security
   that Unix releases do. There are numerous known
   bugs and inconsistencies. There is also a much
   greater chance of security holes being present in
   the Win32 version of Apache.

This is a pretty universal axiom. If you need a stable web server, use UNIX. NT is just for sandboxes that can crash a few times everyday.

In Apaches' config files you'll see things like this:
Alias /icons/ "C:/Apache/icons/"
Alias /papz/ "C:/oas/panama/server/papz/"
Alias /ptgadmin-doc/ "C:/oas/panama/doc/"
It's OK, even though you're on Windows NT. Apache seems to convert the / into \.


In the database, if you need an advanced level of security without a lot of programming you can use a solution out of the box provided by Oracle: Oracle Secure Access. It is based on the Virtual Private Database features provided by Oracle 8i, i.e. fined grained security or row level security. Oracle Secure lets you define policies, labels that you assign to rows and users and groups. This can all be done with a GUI administration tool or through an API.

Wireless Technologies

Nokia 770 does not support the POST method correctly when sending data to the web server, even though this is part of the specification, and the reference material from Nokia claims just the opposite. As a result you have to use the GET method.

JSP: Java Server Page works like PSP (PL/SQL Server Page): there is an engine that reads the HTML page, transforms it in Java code, compiles it and run it. the PSP engine creates a procedure in the database and runs it.

Creating Servlets in JDeveloper is as simple as File->New->Servlet, go through wizard, right click and run!


Cherokee is Forms 7, the hottest thing at ODTUG 2000. At long last!!!! Forms deployed on the web as HTML (mostly). No more presentation applet stuff. There is still a Java applet run by the browser but it only handles communication, not display. Its foot print is currently 120K and might go up to 200K.


Live Demo of Oracle Designer Web Assistant 6.0
Running on an Application Server in The Netherlands, this is a live demo of the Oracle Designer Web Assistant, providing an overview of all its functionality.

Updateable Views

You need to tell forms which columns are read only otherwise all updates will fail. (feature).

SQL*Navigator (version?) drops the instead of triggers of an Updateable views when you try to modify the view's definition. (bug).

Instead of triggers are very powerful, but ...  don't expect Forms to perform any locking when a user starts updating a record on the screen of a client-server application...

iPortal 3.0.

This is the new name for WebDB. Or is it Oracle Portal? This stuff changes every day!

iPortal delivers the single sign-on. Quite logical when this thing is going to present portals from different systems onto the same screen.

Hervé Deschamps is a Technical Manager with Oracle Corporation. Over the years he has developed a number of applications using Oracle Development Tools and others.  He has an extensive experience of all phases of the development life cycle. He is also known in the technical community for his article publications centered around best custom development practices and for his user group presentations. You can reach him by e-mail at herve.deschamps@.oracle.com. He also maintains a web site full of articles, scripts, tips and techniques at http://www.iherve.com.