APEX

Hi,

I am investigating the best practice/approach for multilanguage support. We have european and chinese users.

Here (briefly) is what I would like to do

SELECT colx "alias"
FROM T
WHERE coly = :a

If I am servicing an english user then the alias string might be something like name, address, tel etc.
If I am servicing a chinese user then alias might be something like 名字 etc....

In other words I want reports with english columns for english users and chinese columns for chinese
users.

It would be nice to store different versions of the same SQL statement in a table and do the following:

SELECT q INTO vc_query FROM app_queries WHERE lang = 'Chinese'
then return the SQL statement OR
EXECUTE IMMEDIATE vc_query USING IN vc_constraint INTO c1, c2 etc....

Another related issue: what is the best practice for setting NLS..... on the fly ie. when the user
is authorised ?

Any advise, best practice appreciated.

best regards,

Mark Battersby
email: mark.battersby@ctseurope.cn