Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OSB: How to recreate reusable XQuery functions

1033781Jul 11 2009 — edited Jun 21 2013
OSB's XQuery implementation does not support the XQuery "module" which allows the creation of a function library so how can OSB provide function re-use?

I know you can create XQuery transformations that can be called but these always need a "body" that makes a specific call so I'm finiding I have to copy useful XQuery functions from one transformation to another. Ideally I should be able to call an XQuery function external to the transformation.

Does anyone have any pointers on this or is it a fundamental limitation of the OSB XQuery implementation?

regards

Comments

Sergio-Oracle
Mark,

You're in luck. HTML DB has quite comprehensive translation capabilities. For what you're trying to do, I'd keep the column header text defined in the report attributes rather than in the query itself through an alias. Column headers, like most other attributes in HTML DB are translatable text strings.

You may want to take a look at the user's guide to see how tranlations work.

Sergio
417192
Sergio,

Thanks for the prompt reply.

I think I understand your answer, but I'm not sure how to test it.

Suppose I want to display the results of the following in
Chinese

SELECT ename "name", sal "salary"
FROM EMP;

Can I assume this will create a report with chinese
column names ?

How to test this ?

best regards,

Mark Battersby
email: mark.battersby@ctseurope.cn
Sergio-Oracle
Mark,

There is more to it than that. You'll need to translate (or have someone translate) the strings you want to appear in a different language. Then, you'll need to make your application aware that a translation exists and define when and when you want the translated version to be used instead of the original version.

The steps are outlined in the user's guide under the heading "Understanding the Translation Process" Let me know if you have trouble finding it.

Sergio
417192
Sergio,

Thanks for the prompt reply. I will read this and perhaps ask you some follow up questions to confirm my understanding.

best regards,

Mark Battersby
email: mark.battersby@ctseurope.cn
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 19 2013
Added on Jul 11 2009
9 comments
10,482 views