SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL MAIL a positional parameter association may not follow a named associat

845474Jun 21 2011 — edited Jun 21 2011

I am trying to sale 2 emails, I got the code like this

{code|
utl_mail.send(sender => 'skid@xxxx.edu',
recipients => 'rechever@xxxx.edu','rchever88@xxx.edu',
subject => 'Banner Duplicate Report '||trunc(sysdate)||' Process for Managing Known Duplicate Reports',
message => 'You are about to receive a report with possible duplicates in the Database, THIS IS A TEST' ||chr(10)||chr(13)||

I am getting this error... 
PLS-00312 a positional parameter association may not follow a named association.... 
I try to separate the email by ; does not work either... 

Thank you  
Ps I changed the real emails by xxxx

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2011

Added on Jun 21 2011

3 comments

2,367 views