bildwelt
E2E FORUM
E2E Bridge E2E Commerce

Reply To: Complex data types in Oracle stored procedures

E2E Forum General Discussion Complex data types in Oracle stored procedures Reply To: Complex data types in Oracle stored procedures

#657

Christof
Blocked

Andi,

I think it’s a creative solution to a the problem! So far, when I came across this requirement, I also solved it with xml as input to the SQL adapter, but didn’t have to deal with the XML to Oracle Objects transformation within Oracle.

If I understand you correctly, an alternative approach to solving your problem 3 would be to use xmlOptions in the classToXml() operation, and defining a dateFormatString like %F:

http://docu.e2ebridge.com/classToXML#

For the NLS_DATE_FORMAT option, we do something similar  with NLS_LANG, see CON-726.

Regards,

Christof