Robert wrote:Identify the oracle session and kill it..hurry up!
I have created an email functionality in APEX 3.0.1.00.08 using the following procedures:
DB VERSION: 10.2.0.4.0
P_TO => P_TO,
P_FROM => v_from,--p_from,
P_BODY => p_mailbody,
P_BODY_HTML => p_mailbody_html,
P_SUBJ => p_subject
I am using the the above mentioned two procedures in a page process. In the page process I defined two cursors:
1. cursor: I select the email adresses (P_TO).
2. cursor: I define the number of emails that should be sent to the selected email adresses. At this step we commeted an error: our cursor delevers us more than 1.000.000 records.
So we have been reciewing anormus number of emails for 12 hours without end.
Is there any way to stop/empty the procedures?