Re: How to send email from pl/sql in 806?

2001-05-31 Thread Saurabh Sharma
30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What

RE: How to send email from pl/sql in 806?

2001-05-31 Thread Kevin Lange
]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always

Re: How to send email from pl/sql in 806?

2001-05-31 Thread Jared Still
9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512

Re: How to send email from pl/sql in 806?

2001-05-31 Thread Saurabh Sharma
.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all

Re: How to send email from pl/sql in 806?

2001-05-30 Thread Jared Still
On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: How to send email from pl/sql in 806?

2001-05-30 Thread Jared Still
, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What

RE: How to send email from pl/sql in 806?

2001-05-29 Thread Venkata Ramana Kanchinadam
] Sent: Friday, May 25, 2001 1:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to send email from pl/sql in 806? hi sharma The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5 onwards , thats the reason you were getting compilation errors

Re: How to send email from pl/sql in 806?

2001-05-25 Thread Saurabh Sharma
HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared, and so does for utl_tcp.get_line and utl_tcp.write_line how do we fefine them. where is this package utl_tcp pls explore. thanks. - Original Message - To: Multiple

Re: How to send email from pl/sql in 806?

2001-05-25 Thread Paul Drake
Saurabh Sharma wrote: HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared, and so does for utl_tcp.get_line and utl_tcp.write_line how do we fefine them. where is this package utl_tcp pls explore. thanks.

RE: How to send email from pl/sql in 806?

2001-05-25 Thread Venkata Ramana Kanchinadam
PM To: Multiple recipients of list ORACLE-L Subject: Re: How to send email from pl/sql in 806? HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared, and so does for utl_tcp.get_line and utl_tcp.write_line how do

Re: How to send email from pl/sql in 806?

2001-05-25 Thread Saurabh Sharma
to send email from pl/sql in 806? HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared, and so does for utl_tcp.get_line and utl_tcp.write_line how do we fefine them. where is this package utl_tcp pls explore

Re: How to send email from pl/sql in 806?

2001-05-25 Thread OKhalid
]] Reply To: [EMAIL PROTECTED] Sent: Friday, May 25, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to send email from pl/sql in 806? HI, i tried creating this procedure. but it results into compilation errors. says.. utl_tcp.connection must be declared

Re: How to send email from pl/sql in 806?

2001-05-22 Thread OKhalid
try this procedure it works just replace the IP address in the line c := utl_tcp.open_connection('192.168.1.1', 25); with the IP address of u'r mail server regards __ Omar Khalid Software Engineer LMKResources A LANDMARK AFFILIATE (Formerly Mathtech Pakistan

Re: How to send email from pl/sql in 806?

2001-05-22 Thread Jared Still
A robust implementation of this would require a ProC or Java external routine. A search of the web would probably turn up some likely candidates. Jared On Tuesday 22 May 2001 20:35, Oracle DBA wrote: Hi, I am aware that 817 supports UTL_SMTP for this same functionality. But how can one