Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
›
Platform as a Service (PaaS)
›
Oracle Technology
›
SQL & PL/SQL
Send sms
Send sms
Send sms
|
10-07-2010, 07:39 PM,
|
|||
|
|||
Send sms
procedure is as.... Create or Replace Procedure SEND_SMS ( p_sender in varchar2, p_recipient in varchar2, p_message in varchar2) as mailcon utl_smtp.connection; begin mailcon :=utl_smtp.open_connection('mail.thxis..com'); utl_smtp.helo(mailcon,'mail.thxis..com'); utl_smtp.mail(mailcon,p_sender); utl_smtp.rcpt(mailcon,p_recipient ); utl_smtp.data(mailcon,'From: ' ||p_sender|| utl_tcp.crlf|| 'To: ' || p_recipient ||utl_tcp.crlf || 'Subject: SMS From Database' || utl_tcp.crlf || p_message); utl_smtp.quit(mailcon); end; executing as exec SEND_SMS('test@thxis.com', '9921182989@ideacellular.net','This is my first SMS'); getting error as ORA-30678: too many open connections ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 246 ORA-06512: at "SYS.UTL_SMTP", line 115 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "APPS.SEND_SMS", line 8 ORA-06512: at line 1 at which position i get wrong.... by using same process mail going correctly but sms is not going it throwing error |
|||
« Next Oldest | Next Newest »
|
Users browsing this thread: 2 Guest(s)
Current time: 11-22-2024, 07:43 AM
Powered By MyBB, © 2002-2024 MyBB Group.