oracle utlmail problem

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 363,825 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,490 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 544 | Replies: 0

•

Join Date: Apr 2008

Posts: 75

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Junior Poster in Training

oracle utlmail problem

May 11th, 2008

This what i do; Can anyone tell me whay i receice an error.

1- Run "SQL Command Line".
2- connect / as sysdba. "No error".
3- @?/rdbms/admin/utlmail.sql. "Created and no error".
4- @?/rdbms/admin/prvtmail.plb. "Created and no error".
5- GRANT execute ON utl_mail TO SYSTEM; "No error"
6- Open my "Oracle SQL Developer" GUI.
7- Type code blow as it is and run;

Help with Code Tags

(Toggle Plain Text)

BEGIN
  EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = authsmtp.streamline.net';
  UTL_MAIL.send(sender => 'root@florya.co.uk',
            recipients => 'root@florya.co.uk',
               subject => 'Test Mail',
               message => 'Hello World',
             mime_type => 'text; charset=us-ascii');
END;

8- I receive this error;

Help with Code Tags

(Toggle Plain Text)

Error starting at line 1 in command:
BEGIN
  EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = authsmtp.streamline.net';
  UTL_MAIL.send(sender => 'root@florya.co.uk',
            recipients => 'root@florya.co.uk',
               subject => 'Test Mail',
               message => 'Hello World',
             mime_type => 'text; charset=us-ascii');
END;
Error report:
ORA-00922: missing or invalid option
ORA-06512: at line 2
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

I use:
- Oracle 10g Express edition
- Win XP Prof SP2

Thanks