ora-30678 two many connections are open
we have getting error while running the particular procedure for sending the mail using the utl_smtp packages.
Detail of the applications Front end application VB6 backend oracle 9.2,write now oracle server is configured in MTS,while executing procedures ,that procedure use to send the mail .It pick the data from table,send it using the oracle package utl_smtp.When we calling the procedure from front end we have getting the ora-30678 two many connections are open,At max the session opened will be 200.I am awaiting for Reply's
Thanks in advance
Use dedicated server connection.
And then try again.
Click Here to Expand Forum to Full Width