The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
93 views

Setting the SMTP_OUT_PARAMETER in 10G at runtime

I am writing a procedure that will send mail from oracle 10g. I have installed the UTL_MAIL and UTL_SMTP packages and configured the SMTP_OUT_SERVER parameter. However the requirement is that the SMTP ...
0
votes
0answers
38 views

question on oracle query performance/tuning

we have a query with large union all with a lot of tables. If that query gets hung up, it will hold up alter statements on those tables we should break the query up into individual ones to minimize ...
0
votes
0answers
308 views

Extracting node names by looping through xml in Oracle 10G Plsql

I have an XML that looks like below, <email_details> <VENDOR_ID>73</VENDOR_ID> <RGP_NUMBER>1234</RGP_NUMBER> ..... ..... (any number of ...