SERPland Flugverkehr/Airtraffic Zürich – Auto Direktimport Dänemark – Disneyland Paris – Legoland Deutschland


PL/SQL Tutorial

The site  published a great SQL Tutorial, but unfortunately no PL/SQL Tutorial on exists.

Ok, I understand that Oracle’s PL/SQL is not directly a www language. It’s located at the backend database, mostly Oracle.

But maybe a PL/SQL Tutorial will be adding in the future? Could be in the category of “MORE…”


Also I thought myself creating such a learning video, but PL/SQL’s functionality scope is very wide – will be a huge work to do

Related Posts:


Oracle Reports and Forms SSL (HTTPS) calls

On Oracle Reports and Forms calls, for security reasons, Reports user should not see the Oracle Reports URL with Userid and Password parameters.
We use "manual" Reports calls out of Forms. So we just create the URL string and open this url with web.show_document().
Because Oracle Reports uses the GET method (instead of the POST method) to pass parameters, all parameters are visible to the user within the URL (....&userid=xxx/xxxx@xxxx)
Wo when using Oracle Reports and Forms direct URL calls, I suggest to use to two steps to secure it up:

Related Posts:


Oracle Forms Source Control / Concurrency Control

We're using Oracle Forms source control outside of Forms. Currently we're very happy with our VSS setup. So we are using Microsoft's Visual Source Safe for Oracle Forms Source Control.

Generating *.fmb files out of Oracle Designer, we do a check in of fmb files after generation.

Also there's a possibility to use ANT for SQL and fmb Forms deployment. Using VSS as Oracle Forms source control software, ANT can also check out specific fmb versions to deploy.

At the moment, some peole thing about migrating our Oracle Forms source control software from VSS to something new like SVN (Subversion). But this would be a major change on our developement approach. Currently, the developers were used to VSS with its pessimistic locking mechanism. New version control tools as Subversion are using optimistic locking instead. What's the difference?


Related Posts: