globalwm
asked on
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.c om',subjec t='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?
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
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Now, onto the next errors:
ERROR at line 1:
ORA-29540: class oracle/plsql/net/TCPConnec tion 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
ERROR at line 1:
ORA-29540: class oracle/plsql/net/TCPConnec
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
ASKER