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:

Post a Comment

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio