SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IS_NUMBER function?

493358Mar 15 2006 — edited Jan 16 2009

I wrote a very primitive function to check if the contents of a VARCHAR field is Numeric. The function simply checks if every character in the field is between 0 - 9.

I feel like this is a very inefficient way to check for numeric/non-numeric data.

Is there a better way to do it?

843830

oops,
http://forum.java.sun.com/thread.jsp?forum=43&thread=248736
same topic

843830

anyway
assumption: we have a list of delivery failures
-> message.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);
-> and report-type=delivery-status (Content-Type)

any comments ?

843830

i think i found something
-> Final-Recipient (http://www.ietf.org/rfc/rfc1891.txt)

i will test it and post if it works..

843830

Should the notify failure send by the sender's SMTP server or the Recipent's server?
If it is sent by the Recipent's server, we have no control of the delivery status notification's format?

Thanks!

843830

If it is sent by the Recipent's server, we have no control of the delivery status notification's format?

if you set a notify-option (FAILURE,SUCCESS,NEVER,..) the recipient's server must answer with a RFC 1891 DSN ( if RFC 1891 is supported by the server)

??

(just a theory)

843830

Hi, Starzer, thank you!

In one of your previous messages, you said the following can be used:
-> message.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);
-> and report-type=delivery-status (Content-Type)

What is the object type of the message? I could not find the function setNotifyOptions() :(..

By the way, I am thinking of writing my own ESMTP server too. How long do you think it will take for a java programmer? (Only implements the simple sending out functions and bounce back notifications). Any suggestions for where to start and sample code?

Thanks a lot!

843830

-> com.sun.mail.smtp.SMTPMessage

we have built a small smtp server which is able to receive emails (just implement a few smtp commands)

there are some implementations (with source) somewhere (-> google )

843830

Hi,
I have the problem that I don't receive any faliure notification even though I have

SMTPMessage.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);

Any idea why ? I tried to send an email to a non existing address like tyty@cox.net

If I use my outlook to send a message to this address, I get a message
Your message did not reach some or all of the intended recipients.

Subject:
Sent: 3/21/2003 3:41 PM

The following recipient(s) could not be reached:

'tyty@cox.net' on 3/21/2003 3:41 PM
The recipient name is not recognized
The MTS-ID of the original message is: c=US;a= ;p=NRTC;l=EXCHANGE-030321204040Z-155810
MSEXCH:IMS:NRTC:NRTC1:EXCHANGE 3550 (000B09AA) 550 Invalid recipient: <tyty@cox.net>

Why don't I receive a similar message when I send the email through javamail ?

Thanks

1 - 8

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2009

Added on Mar 15 2006

14 comments

187,693 views

SQL & PL/SQL

IS_NUMBER function?

Comments

Post Details