Wednesday, June 27, 2007

Apex's sVista

If you have a multi language application in Apex 3.0.0.00.20 and you execute the following query:

select WORKSPACE, APPLICATION_ID, TRANSLATABLE_MESSAGE,
LANGUAGE_CODE, MESSAGE_TEXT, LAST_UPDATED_ON, LAST_UPDATED_BY
from APEX_APPLICATION_TRANSLATIONS
where LAST_UPDATED_ON is not null;

if you get any rows back, you can notice that the two columns names do not match their real content data type:

LAST_UPDATED_ON contains a user name (VARCHAR2) while LAST_UPDATED_BY contains a date.

Just a minor bug i suppose, but who knows if oracle will keep the view as it is for backward compatibility...

That's all for today.

PS: "svista" in italian sounds like "mistake", whereas "vista" is the translation of view.

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles