Wendy and the Oracle

I have a special situation in which I have about 8 webpages, which all have the same button to open a new window.

My problem is that when I press the button on page 1 (which opens a new window), browse to page 2 and press the same button, the url in the popupwindow changed but the data is *not*. In the original situation the url was the same and server vars had been changed, so I figured the browser simply did not make a new request, but even after changing a dummy variable in the url the data does not refresh until I press F5. I tried delaying setting the new url, to make sure the server was ready for the request but this didn’t help either. As a last resort I wrote this code, which is ugly as hell but fast enough not to be noticed:

l_Window = window.open(pURL,pName, pParameters);
l_Window.close();
l_Window = window.open(pURL,pName, pParameters);

Now I get fresh data everytime I click the link….
If anyone has a better solution please tell me because I am not very happy with this one…

do not go together (yet).

Today I needed a standalone Apache and what seemed logical to me is that I installed it from the Application Server Companion CD (10.1.3). It never occurred to me that the Apache you get with your iAS is not the same you get when you install it from the Companion CD. The companion CD will give you Apache 2.0, which according to http://www.oracle.com/technology/products/ias/ohs/htdocs/ohs-1013-faq.pdf does not support mod_plsql, even thought the startpage says this at the bottom:

mod_plsql users should refer to the “Creating a DAD” section in the Oracle HTTP Server Standalone Administrator’s Guide Based On Apache 2.0.

(I haven’t been able to locate this guide yet)

Instead, there is an advanced option on the iAS installation CD, which lets you select a standalone webserver, which is indeed Apache 1.3.

Something I learned today:
When you want a dos batch file to run a few commands and some of them are also batch files, use “call” to start them, or else your script will stop after having called the first batch file.

Example:
file=test1.bat:
echo hi

file=test2.bat
call test1.bat
call test1.bat

output:
hi
hi

Yes people, Wendy too has given in and started a blog.

Please don’t expect any rants about my personal life though, I start this blog as a personal archive for storing my experiences with Oracle. I have been working with Oracle’s products for a year now and I am sure people agree with me when I say that there is not a single Oracle product that does what you want right away.

Read and learn from the mistakes I made and the tricks I found…..