Running Oracle SQL Developer 3.0 under Ubuntu

Since Oracle doesn't provide the file deb for Ubuntu, you need to download Oracle SQL Developer for other platforms (usually is a zip file that doesn't not include a JDK), and follow the instructions below:

http://oracolodeidb.blogspot.com/2009/04/ubuntu-e-oracle-sql-developer.html

PS. As described in the article, I also needed to execute the following command:
$ cd ~/.sqldeveloper
$ echo /usr/lib/jvm/java-6-openjdk > jdk

Italian Postal Codes

The full list of italian postal codes (CAP), ready to use!

http://italy.fsfe.org/it/projects/cap/

See also:
http://www.michelem.org/2006/09/29/tutti-i-nuovi-cap-italiani-come-ottenere-il-database-completo/

Flow charts on line

this web site is very very nice
http://yuml.me/diagram/scruffy/class/draw

Remote Desktop under Linux

I've refined the parameters for rdesktop, to perfectly work with my resolution and my italian keyboard:

rdesktop -u administrator -g 90% -k it -PKD $IPaddress

PL/SQL into T-SQL

It's unbelievable!
Microsoft provides free tools to migrate database objects (stored procedures included) to SQL Server. Very very useful.

SSMA: Migration Made Easy
http://www.microsoft.com/sqlserver/2005/en/us/migration.aspx

CPU-Z

I've just discovered a program which allow us to know how many RAM banks are mounted inside our pc!
The program is CPU-Z, and you cand download it from here.

Running Reports with Oracle Report Server 10G using a web browser

Of course, it's possible to run Oracle reports with a simple http request.
This approach only requires Oracle Report Server installed on the machine/server and responding on its port 8889.

• Verify that you have all license rights to install Oracle Report Server


• Install a PDF reader (personally I love foxit reader)


• Verify that these environment variables are set:
  REPORTS_PATH = C:\your_reports_folder;
  PATH=C:/DevSuite10_home;C:/OLD_DevSuite9_home;etc...
  Important: Make sure your latest Dev
  Suite is on your PATH environment variable first, before any older versions!


• Start OC4J


• Start your web browser and run your report using this sintax:
  http://<reports server name>/reports/rwservlet?report=<report file name>&<other report parameters>

Example:
http://localhost:8889/reports/rwservlet?report=rep_007.rep&userid=username/password@192.168.19.58:1
521/ORCL&desformat=pdf&destype=cache&YOUR_REPORT_PARAMETER1=image.bmp&OTHER_REPORT_PARAMETERS=...

Common problems:
If your report calls other libraries, these must be in the same directory of the report, and must be compiled/recompiled with Oracle reports builder 10g.

To avoid errors like the following:

Not able to load oracle.reports.util.EnvironmentGlobal class
Using oracle.reports.util.Environment class

you must also generate/regenerate REP file using 10g Report Builder AND check whether the file/folder has enough privilege to the logged in user.
If you still have problems try to copy it to another folder: there might be problem with the acess right in your folder.

For reference:
Useful guide to Oracle Reports http://www.rittmanmead.com/files/quick_start_guide_oracle_reports.html
Using the Oracle Reports Web Service http://download.oracle.com/docs/cd/B10464_05/bi.904/b13673/pbr_webservice.htm
In the case that you can't use report server and you're forced to use something on the clients, thake a look at
http://www.orafaq.com/forum/t/37321/2/