Home » SQL & PL/SQL » SQL & PL/SQL » implement package utl_mail issue ... (Window , Oracle 10.0.2)
implement package utl_mail issue ... [message #564717] Mon, 27 August 2012 22:45 Go to next message
JADYCHEN
Messages: 82
Registered: July 2010
Member
Hi!! All Experts ,
I want to implement package utl_mail , then :
I Execute below script user : sys,
@$ORACLE_HOME\rdbms\admin\utlmail.sql ---> ok!!

but , When I execute this script :

@$ORACLE_HOME\rdbms\admin\prvtmail.plb

it show an error :
compiled PACKAGE BODY utl_mail
85/2 PLS-00114: ID 'CSZW046BRTZGLOXQJ2JU1ODNYDMYN3' to long
85/2 PLS-00103: find symbol "CSZW046BRTZGLOXQJ2JU1ODNYDMYN3"
87/0 PLS-00103: symbol "end-of-file" when you wait below:

. ( * @ % & = - + < / > at in is mod remainder not rem when
<指數 (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || member SUBMULTISET_

I do'nt know how to fix it , Please All Experts help me , Thanks!!
Re: implement package utl_mail issue ... [message #564719 is a reply to message #564717] Mon, 27 August 2012 22:54 Go to previous message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
It works for me.


20:52:56 93
20:52:56 94 /

Package body created.

20:52:56 SQL> show errors;
No errors.
20:52:56 SQL>

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: index was outside the bounds of array
Next Topic: decode function
Goto Forum:
  


Current Time: Thu Dec 18 04:01:13 CST 2014

Total time taken to generate the page: 3.76769 seconds