The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
16 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
1answer
23 views

SQLPlus Padding in Query Results

I have several Oracle servers that exhibit a behavior I do not understand. I have identified a two node RAC in which one node exhibits the behavior, but the other node does not. RAC is not involved ...
0
votes
0answers
24 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 ...