Martin Giffy D'Souza on Oracle APEX: Variables in APEX

Martin Giffy D'Souza on Oracle APEX: Variables in APEX: "When I first started using APEX I was unsure about which method to use when referencing variables (values in session state). The purpose of ..."

APEX Popup LOV with more columns

Today I found a really neat plug-in to Oracle's APEX.

Have a look here: http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-super-lov_75.html


All's well, ut there is a downside to using this plug-in. Cascading Parent LOV's are not supported yet. I hope they will soon. So I came up with an alternative that does use the native popup LOV.

• I altered the template that displays the LOV to use a fixed with font for the body
• I use LPAD and RPAD in combination with ' | ' to neatly outline the columns

the result looks like this:

Maybe is not the most beautiful solution, but it suffices for now.

APEX 4.0.2 is installed

OK Guys,

APEX 4.0.2 has been installed without any trouble. just follow the instructions provided by Oracle.

Digital Nativity

This you gotta check out.

Fantastic:

Oracle Database Development Tools (ODDT): APEX 4.0.2 is here, and its got two new themes!

As soon as I find the time I'm going to investigate further:

Oracle Database Development Tools (ODDT): APEX 4.0.2 is here, and its got two new themes!: "Oracle Application Express (APEX) 4.0.2 patch is now available on MySupport and a re-release is available on OTN as of last Friday November ..."

Oracle 11g on Windows DBConsole does not start

Wow. I have broken my thoughts about this for a loooooong time. In the end stuff can be so simple:

When you get the errormessage that it cannot  start the DBConsole do this:

• Make sure you have the MS loopback adapter installed (remember my previos Blog-entry)
• Make an entry in your hosts file:
  xx.xx.xx.xx yyyy
  where xx.xx.xx.xx is your fixed IP-number on the MS Loopbackadapter and yyyy is your computrename
• Restart the service

That should do the trick

Great thanks to http://www.ywema.com/yweblog/2008/09/oracle-11g-dbconsole-en-apex/

Oracle DB on a notebook

If you want to install an Oracle database on a notebook, then it is essential that beforehand you install the MS Loopback adapter. This is a "virtual" network adapter.

After installation assign it a fixed IP-addres (192.168.99.99 for example) and you're ready to install the Oracle Listener and Database instances.

You should not believe people who claim that Oracle doesn't need it anymore. Maybe Oracle can do without the loopback adapter, but it will prevent a lot of issues that you would need to solve manuallly.