Skip to main content

Posts

Showing posts from January, 2017

Sending mail by Telnet and manually checking connection

Open Command prompt using CMD as administrator Then Put in this command : telnet server Name 25 Wait to be invited to next step (ehlo), then put in this command: EHLO   Domai nanme After output put in this command: MAIL FROM : From email address After output  ("Sender OK"), then put in this command: RCPT TO : to email address After output  ("Recipient OK"), then put in this command: DATA After output , then put in this command: Subject : type message After output , then put in a dot (".") and hit enter. After output  and confirmation message, then put in this command: Then  QUIT

Advantages of pragma exception init in ORACLE

1.You can define error message for predefined oracle error number.. But once you declare pragma statement, exception are handled implicitly... No need to raise exception explicitly... 2.User could define error message for predefined ora- error number. I guess this would be advantage of using it.. 3.The pragma actually makes it possible to check for errors which are not predefined. the only other way would be to check with 'WHEN OTHERS' clause and then accessing the oracle error code. 4.To enhance application interface and display accurate reason for an error.