Завершен

XML XQuery transform with call to PL/SQL

I need to transform some values in XML records using calls to a PL/SQL function.

I require this functionality to be contained in a PL/SQL function called fn_fe() whose prototype is as follows:

FUNCTION fn_fe( var_xpath VARCHAR2, var_rec XMLTYPE ) RETURN XMLTYPE;

Where:

var_xpath = A string representing an XPath of all matching elements whose value/attribute is to be modified.

var_rec = The original XML record

Return = The modified XML record

From within fn_fe(), it is expected that XQuery is used to parse the XML record for matching paths. At some point, you must call the PL/SQL function my_transform(), supplied below, to obtain the transformed value for each matching element original value. Note: Do not rewrite the my_transform() as XQuery code. The whole point of this requirement is for fn_fe() to call a PL/SQL function (i.e. my_transform()) to perform the transformation on each element value that matches the path.

CREATE OR REPLACE FUNCTION my_transform( orig_value INT) RETURN INT

IS

BEGIN

RETURN orig_value + 100;

END;

OTHER REQUIREMENTS & CONSIDERATIONS:

- It is expected that on each call to this function fn_fe(), approximately 0 - 20 paths will match. i.e. that many values will need to be updated per XML record. Please mention the word "stereo" in your bid so that I know you have read this spec. The XML test record shown in attachment is a much smaller fictitious example for clarity and test purposes. The real XML records will typically contain between 100 and 500 elements, some may be larger.

- It is expected that this function will be used to process 5 million XML records on a periodic basis, so this must be as efficient as possible.

DELIVERABLE:

- The complete PL/SQL function fn_fe() as described. I should be able to just compile the supplied my_transform() and your fn_fe(), and then calling fn_fe() should return XML records matching those shown in Test1 and Test2 of attachment.

Навыки: XML, XQuery, Oracle

Показать больше: oracle xml query where clause, oracle xmlquery examples, oracle xmltable, oracle xml examples, oracle query xml in clob, oracle xml query examples extractvalue, oracle xml tutorial, oracle xml extract attribute value, xml xsl transform flat file, sql file input read, reading xml file table using sql, sql anywhere database read file, using xml file insert records sql table, sql excel file read, xml website transform xsl, php xml data different server sql, apex pl sql developer, free javascript projects pl sql, freelance oracle pl sql, freelance pl sql

О работодателе:
( 4 отзыв(-а, -ов) ) Coburg North, Australia

ID проекта: #27572959

Поручен:

dohungnd94

Dear employer. stereo. I have read your requirements carefully. With over 5 years experience working as plsql developer. I will help you create a function which return an updated xmltype value. I am working for ban Больше

$140 AUD за 3 дней(-я)
(0 отзывов(-а))
0.8

4 фрилансеров(-а) готовы выполнить эту работу в среднем за $205

adeeladeel1234

Hi i am expert programmer for sql plsql xml xslt xquery , i can do this task proficiently please do review my profile and send me message to discuss your requirements in details

$278 AUD за 1 день
(55 отзывов(-а))
6.0
MWaqar5246

Greetings, have previously worked over transforming calls over PL/SQL Database usinG XML Query as we have done similar work in the past. We are a team of professional developers having years of expertise over Php, HTML Больше

$150 AUD за 6 дней(-я)
(0 отзывов(-а))
0.0
wahmad1983

Hi Team, Hope you are doing good. I am having around 11 years of IT experience which Includes mainly in the area of Database development,Design,Maintenance,Management along with worked on many data Warehouse projects. Больше

$250 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0