Hello all,I am working with a query that does some counts. I've hit a brick wall and can't get passed trying to figure out how I can make the query show percentages %.Here is the query:select "COUNTRY", count ("MSS") "COUNT_MSS"FROM (SELECT
http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
ugh.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bricklen AndersonINET: [EMAIL PROTECTED]Fat C!
ity
Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---
: Bricklen Anderson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E
PROTECTED]
Subject: SQL Query Problem(possilble duplicate send, Sorry!)
Date: Tue, 13 Jan 2004 12:34:35 -0800
Hello all,
I am working with a query that does some counts. I've hit a brick wall and
can't get passed trying to figure out how I can make the query show
percentages %.
Here is the query
Isn't the wall utility used to send a message to everyone in Unix/Linux?
i.e
wall This Database will Self Destruct in 5 seconds
(although the utility has been removed from some systems due to some
security problems a.k.a root exploit)
p.d : What's Outlook Express??? ;)
-Original
the wall utility used to send a message to everyone in Unix/Linux?
i.e
wall This Database will Self Destruct in 5 seconds
(although the utility has been removed from some systems due to some
security problems a.k.a root exploit)
p.d : What's Outlook Express??? ;)
-Original
]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED
If your users are part of your local network, you can use
the Windoze NET SEND command. I have recently found that
to be useful.
UNIX/Linux utilities like 'wall' only send a message to
users who are telnet'ed or rlogin'ed to the system.
To send a message to a browser is not something I know
how
i can't use net send since not all users in the same local network.
i can't also wall since all users are using win98.
do u know any 3rd party software like winpop(forlocal network) that can
send messages across the network?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
I think that you're going to have to take Mladen's advice
and send an Email to everyone
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
i can't use net send since not all users in the same local network.
i
hi,
I need to send messages like 'system shutting down in 1 min' to all users
currently login.
How can i do this in oracle or a third party software that i can use? users
are connected using web browser. Messages are send over the wan.
thanks.
--
Please see the official ORACLE-L FAQ: http
an important database is not a DBA decision but a
decision made
by people who manage the normal business process. Those people are sometimes referred
to
as management. They are the ones who make decisions and define schedule.
On 2003.11.25 20:49, [EMAIL PROTECTED] wrote:
hi,
I need to send messages
to send mail from windows command
prompt?
Check out a dos
program called BLAT. I think that is what you are looking
for.
Erik
-Original
Message-From:
Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:19
PMTo: Multiple recipients
of list ORACLE-L
Subject: how to send mail from windows command prompt?
Hello All:
I have setup some scripts that would export the db every day.
Instead of
looking through the logs manually every morning, is there a
way to tail
(windoze equivalent?) the file and send and email
: Multiple recipients of list ORACLE-L
Assunto: how to send mail from windows command prompt?
Hello All:
I have setup some scripts that would export the db every day. Instead of
looking through the logs manually every morning, is there a way to tail
(windoze equivalent?) the file and send and email
I use Postie with Perl also. Perl does the log file searches for error and
uses postie to send mail.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, October 03, 2003 5:14 AM
To: Multiple recipients of list ORACLE-L
Yes, doing this all the time, all
:\connection.txt
GOTO begin
##
HTH !
Bob
Hello All:
I have setup some scripts that would export the db every day. Instead of
looking through the logs manually every morning, is there a way to tail
(windoze equivalent?) the file and send and email
If you want an SMTP enabled mailer, similar to mailx, just send me a note, privately.
Your absolutely welcome to it.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, October 03, 2003 5:14 AM
To: Multiple recipients of list ORACLE-L
Yes, doing
:RE: how to send mail from windows command prompt?
I use Postie with Perl also. Perl does the log file searches for error and
uses postie to send mail.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, October 03, 2003 5:14 AM
To: Multiple recipients
Professional
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, October 03, 2003 2:29
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
how to send mail from windows command prompt?Tom, If
you're mailing from Perl, why not just use 'use
Check out a dos program called BLAT. I
think that is what you are looking for.
Erik
-Original Message-
From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003
3:19 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: how to send mail from
] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how to send mail from windows command prompt?
Tom,
If you're mailing from Perl, why not just use 'use Mail::Sendmail'?
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent
Hello All:
I have setup some scripts that would export the db every day. Instead of
looking through the logs manually every morning, is there a way to tail
(windoze equivalent?) the file and send and email (mailx equivalent on
windows?) I know this can be implemented in Perl, but I don't know
Title: RE: how to send mail from windows command prompt?
Murali,
I am using blat and it is working great. You could download necessary software from www.blat.net
Thanks,
Rama Ari
Database Administrator
[EMAIL PROTECTED]
610.964.5128
-Original Message-
From: Murali_Pavuloori
services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list
services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you
Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling
this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other
:[EMAIL PROTECTED] On
Behalf Of Oracle DBA
Sent: Tuesday, September 09, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
Subject: How to send an email from unix command line?
Hi List
I tried the following stuff but it says Service
Unavailable.
$mail -s Test Subject [EMAIL
Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
-
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other
Thank you, thank you! I'm doing my best.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Thater, William
Sent: Tuesday, September 09, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to send
://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY
If you wanted to send as an attachment use 'elm'
Madhu Reddy
-Original Message-
Sent: Tuesday, September 09, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Hi List
I tried the following stuff but it says Service
Unavailable.
$mail -s Test Subject [EMAIL PROTECTED]
body
]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: How to send an email from
unix command line
]Subject: RE: How to send
an email from unix command line?
com
09/09/2003 04:24
PM
Please respond to
ORACLE-L
If you wanted to send as an attachment use 'elm'
Madhu Reddy
All,
I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
Unix box to myself when the batch job runs.
Anybody been able to do this? I can send the text of the file, but what I
really want to do is to send the file (it's an Excel Spreadsheet).
thanks in advance.
Tom
Hi!
This should work:
$ sendmail -v [EMAIL PROTECTED]
your_report_file.xls
-v means: verbose
you can skip it!
HTH
JL
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report) from a Sun
Unix box to myself when the batch
UUENCODE the file then send it as text.UUDECODE it back to a file at the
recipient.
-Original Message-
Sent: Thursday, February 13, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
All,
I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
Unix box
://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY
You mean:
mailx -m -s Test Message [EMAIL PROTECTED] EOF
`ux2dos /home/report/tbsp.lst | uuencode
/home/report/tbsp.lst`
This is from an HP-UX system
hth
mohammed
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report
Thomas,
Thursday, February 13, 2003, 9:44:07 AM, you wrote:
M All,
M I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun
M Unix box to myself when the batch job runs.
M Anybody been able to do this? I can send the text of the file, but what I
M really want to do
and statements above are entirely my own and not those of my
employer or clients **
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Send Mail in Unix
All,
I'm
02/13/2003 10:44 Send Mail in Unix
AM
[EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report) from a Sun
Unix box to myself when the batch job runs.
Anybody been able to do this? I can send the text
of the file, but what I
really want to do is to send the file (it's an Excel
Spreadsheet
I use mutt which has the option to attach a file.
mutt -s 'subject' -a filename user@mailserver /dev/null
would send an attachment with no body, put a file instead of /dev/null if you want a
body for the message.
With mailx in unix, I've been told it can be done by piping through uuencode
All,
I guess I made the mistake mentioning Excel.
I am creating a tab delimited text file with an .xls file type that Excel
can easily open. It is not a binary Excel file.
I just need to be able to send the file as an attachement.
thanks again and sorry for the mis-statement!
Tom
Tom,
Here is a perl script that will send the file as an attachment.
HTH
Peter
#!/usr/bin/perl -w
# mail_attach.pl -- Mail files as attachments
# Created new perl script mostly from MLB 11/09/1999
# The Perl Journal 14 mail_attach.pl example
#
# $ARGV[0]: The sender e-mail address
OMG!!!
Thanks to all! It actually works!
This is what works for me:
I run a sql script that produces a tab delimited report showing tablespace
usage (think of the OEM screen showing all the tablespaces with size, used
and free listed).
I then use the following command to send the report to me
/home/report/tbsp.lst | uuencode
/home/report/tbsp.lst`
This is from an HP-UX system
hth
mohammed
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
All,
I'm trying to send an email attachment (Oracle
Tablespace Report) from a Sun
Unix box to myself when the batch job runs.
Anybody been
PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED
you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Janet Linsy
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
.'
|| chr(13));
utl_smtp.close_data(mail_conn);
utl_smtp.quit(mail_conn);
EXCEPTION
WHEN OTHERS THEN
-- Insert error-handling code here
NULL;
END;
/
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers
guide me. If possible please send me the code for doing this.
Regards,
Faiz
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: FAIZ
Hello All:
I am using Oracle Forms 6i. I have a Form where I have to send an email of
the data entered in the Form using Lotus Notes email.
Does anyone know how this can be done ?
Please guide me. If possible please send me the code for doing this.
Regards,
Faiz
recipients of list ORACLE-L
Subject:How to programatically send an email using Lotus Notes from
an Oracle Form ?
Hello All:
I am using Oracle Forms 6i. I have a Form where I have to send an email of
the data entered in the Form using Lotus Notes email.
Does anyone know how this can
Faiz,
I'll make the assumption that your using an Oracle 8i (8.1.6 or better) as
the database server. In which case you can use the DBMS_SMTP package in Jserver
to send the mail to any mail client you want, especially since you obviously can
get Internet mail. Here is a wrapper I've
Hallo,
anyone whom can help me. I would like this code to send email to two recipients, what
is missing?
Thanks for all help I can get.
PROCEDURE sendmailtestny2(
inRecipient1 IN VARCHAR2,
inRecipient2 in VARCHAR2
for the
second recipient.
HTH!
Aleem
-Original Message-
Sent: Friday, April 19, 2002 4:28 PM
To: Multiple recipients of list ORACLE-L
Subject:Send mail from PL/SQL
Hallo,
anyone whom can help me. I would like this code to send email to two
recipients, what is missing?
Thanks
-
Sent: Friday, April 19, 2002 4:28 PM
To:Multiple recipients of list ORACLE-L
Hallo,
anyone whom can help me. I would like this code to send email to two
recipients, what is missing?
Thanks for all help I can get.
PROCEDURE sendmailtestny2
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Abdul Aleem [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 06, 2002 3:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Send mail from pl/sql
/tip.htm#formstips1
HTH!
Aleem
-Original Message-
Sent: Friday, April 05, 2002 8:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Send mail from pl/sql
Two questions:
1) Why should the client matter?
2) What is the web address of the site you mention
have a good example on a procedure how to send email from
Pl/SQL. What I want to happen is to do a select statement and then send a
mail with the result to the address [EMAIL PROTECTED]
Please help me with this. I would appreciate it very miuch.
Thanks in advance
Roland
--
Please see
it for. If it is for MS outlook, you can
check at Perter Koltez's site
Aleem
-Original Message-
Sent: Friday, April 05, 2002 12:33 PM
To:Multiple recipients of list ORACLE-L
Hallo,
Does anyone have a good example on a procedure how to send email from
Pl/SQL. What I want to happen is to do
send_email.sql send_email_attch.sql
-Message d'origine-
De: Abdul Aleem [mailto:[EMAIL PROTECTED]]
Date: vendredi 5 avril 2002 11:18
À: Multiple recipients of list ORACLE-L
Objet: RE: Send mail from pl/sql
Which mail client
: Abdul Aleem [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Send mail from pl/sql
Which mail client are you looking it for. If it is for MS
outlook, you can
check at Perter Koltez's site
Aleem
-Original
List,
I am sending email from the database.
I have UTL_SMTP setup which works fine.
However in the message field I would like to query a table (using
a select)
rather than a hardcoded
message.
Not sure how to do this though.
Anyone got any pointers will be greatly appreciated.
: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list
-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include
Hi friends :
What can I do for send html text using UTL_SMTP.
I have knowledgement using normal text but not with html.
Regards.
Thanks.
Eriovaldo
[EMAIL PROTECTED]
Brazil
_
Seja avisado de novas mensagens do Hotmail e use o
Take a look at the UTL_HTTP package if you want to send and get HTTP
requests. I built a little cross database communication system using this
and ASP pages. One database could post a message that would be picked up by
another database across firewalls since HTTP is usually open. However I
One of our developers just wrote a package to do just that
--
PACKAGE HTML_Mail IS
PROCEDURE Send(P_TO IN VARCHAR2,
P_FROM IN VARCHAR2,
P_SUBJECT
Message - ','Dear friend :
' || chr(13) || chr(10) || 'It is a very good resource' );
Eriovaldo
[EMAIL PROTECTED]
Brazil
From: Janet Linsy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: send email through pl/sql ???
Date: Tue, 17
Hi all,
Does anybody know how to send email through pl/sql?
thank you.
Janet
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hi ,
I want to send SMS message from oracle database .
any help would be highly appreciated.
Tanks in advance.
Shahid Latif
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shahid Malik(IT)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
Basically is to connect from Oracle to talk with your email server. ,the
person in charge is not around here , but I will let you know more detail
for this .
-Original Message-
Sent: Friday, June 08, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Hi ,
I want to send SMS
Shahid,
Here in Hungary GSM service providers have email/SMS gateways:
1. You receive an SMS when an email arrives to your email address, given to
you by you GSM SP. The SMS contains the subject part fo the email. You can
send the information of in the subject part.
2. Or they have a real
then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
this msg is returned with ora 06512
any suggestions..
- Original Message -
From: Jared Still [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED]
Sent: Wednesday, May
the
procedure.
here it goes..
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
this msg is returned with ora 06512
any suggestions..
- Original Message -
From: Jared Still [EMAIL PROTECTED]
To: [EMAIL PROTECTED
then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
this msg is returned with ora 06512
any suggestions..
- Original Message -
From: Jared Still [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED]
Sent: Wednesday, May 30, 2001
error msg which are defined in the exception body
inside
the
procedure.
here it goes..
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
this msg is returned with ora 06512
any suggestions
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
others then
raise_application_error(-2,'Unable to send e-mail message from
pl/sql');
this msg is returned with ora 06512
any suggestions..
- Original Message -
From: Jared Still [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED]
Sent: Wednesday, May 30
]
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
---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
rem Notes: From Oracle8i release 8.1.6 one can send e-mail messages
rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
rem packages. No pipes or external procedures
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want
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
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
* Retrieve the home page from http://www.acme.com/
*
* DECLARE
* c utl_tcp.connection; -- TCP/IP connection to the Web server
* BEGIN
* c := utl_tcp.open_connection('www.acme.com', 80); -- open
connection
*
* utl_tcp.write_line(c, 'GET / HTTP/1.0'); -- send HTTP
Hi,
I am aware that 817 supports UTL_SMTP for this same
functionality. But how can one send email from pl/sql
in 806?
thanx
=
Vicky D. Foster,
Senior Oracle DBA:
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy
Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
rem ---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
send email from pl/sql
in 806?
thanx
=
Vicky D. Foster,
Senior Oracle DBA:
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official
The payload in AQ can be a B/CLOB, and subsequently can
be as large as a B/CLOB is allowed to be. 2 or 4 gig, I forget
which.
There are paper at otn.oracle.com on AQ, go take a look at them.
Jared
On Thursday 19 April 2001 08:13, Henrik Ekenberg wrote:
Hello,
We will send files from one
0 Apr 2001 09:15:40
SHAIBAL TALUKDER wrote:
Raja,
If you have unix mail utility you can send mail form unix. At the system
prompt type -
mailx -s "Subject" [EMAIL PROTECTED] msg
hope this helps.
Shaibal
Viraj Luthra [EMAIL PROTECTED] wrote:
Paul,
I dont need that
Raja,
Do you have your sendmail running, Does it have access to the outside world to be
able to "send" the mail? Check the logs and message status to determine the problem.
ROR mm
[EMAIL PROTECTED] 04/11/01 12:10AM
Hello,
This is the second time I am writing this message, dont
Viraj,
As I remember, your initial query mentioned you were trying to send a
message from an AIX box. First check to see if sendmail is running on
your system. Execute the command ps -ef |grep sendmail . You should
receive a response that includes a line like the following:
root
1 - 100 of 111 matches
Mail list logo