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!

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

Refer to the video below. It shows you how can you connect to a Oracle database and read data into your Excel sheet using VBA programming.
How to connect Excel to Oracle with VBA (0 Bytes)Cheers
Arsalan

User_IKOCL

Thank you.
That solved my problem.

Case solved.

1 - 2
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,517 views