<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='[Email address protected]
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?


Oracle LazyDBA home page