954,597 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

oracle utlmail problem

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;

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;

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

veledrom
Master Poster
758 posts since Apr 2008
Reputation Points: 42
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You