I''m kinda new to using XML in Oracle procedures. Please guide.
1) Can i have (Attached) XML as input to the the stored procedure?
2) If Yes for # 1, I need to "XMLTYPE(extractValue" follwing elements fromthe xml.
a) Needed_Element_1, Needed_Element_2 and Needed_Element_3
b) Multiple More_Elements_Needed_1, More_Elements_Needed_2 and More_Elements_Needed_3
3) Once i have the select query on this XML and get the elements bulk collect into nested table I can use in according in my SP.
Need help with # 1 and # 2.