Using MAIL_FILES procedure (PLS-00201 error)

<Newbie to Procedures and Packages>

I've created the MAIL_FILES procedure successfuly:

http://home.clara.net/dwotton/dba/oracle_smtp.htm

and now, I want to test using:

execute MAIL_FILES ( from_name='oracle',to_name='myemail@mydomain.com',subject='A test',message='A test message');

but I'm getting:

ERROR at line 1:
ORA-06550: line 1, column 20:
PLS-00201: identifier 'FROM_NAME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

(v8.1.7.4 Win2k btw)


Any ideas on what I'm doing wrong?
LVL 1
globalwmAsked:
Who is Participating?
 
biglaxman17Connect With a Mentor Commented:
According to the link that you provided

mail_files( from_name => 'oracle' ,
                to_name   => 'someone@somewhere.com' ,
                subject   => 'A test',
                message   => 'A test message',
                filename1 => '/data/oracle/dave_test1.txt',
                filename2 => '/data/oracle/dave_test2.txt');

You need to add the  >  after the equals sign.

Or you can just leace out the from_name =, to_name  = , etc.....  in the call of the procedure.
0
 
globalwmAuthor Commented:
Thanks, that was (simply) it. Forgot about just specifying the vars...

0
 
globalwmAuthor Commented:
Now, onto the next errors:

ERROR at line 1:
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 537
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "SYSTEM.MAIL_FILES", line 133
ORA-06512: at line 1

heh


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.