PL/SQL (MOSC)

MOSC Banner

PL/SQL Package Error

edited Sep 4, 2009 10:44PM in PL/SQL (MOSC) 4 commentsAnswered
 Hi All,

I have written a package.But am getting following error while executing the package.

[code]

SQL> SQL> BEGIN ODS.PCK_GRDR_MAIL.GRDR_AM02 (500,'FRENCH'); END;

                                    *

                                    *

ERROR at line 1:

ORA-20002: unable to send the mail.ORA-06502: PL/SQL: numeric or value error:

character string buffer too small

ORA-06512: at "MBS.PCK_GRDR_MAIL", line 6303

ORA-06512: at line 1

  [/code]

the line 6303 is defined in an exception ( Marked in Bold red letters in the following) .

WHEN utl_smtp.transient_error THEN count_retry := count_retry -1; IF count_retry > 1 THEN PCK_GRDR_MAIL.GRDR_AM02(count_retry,plang); ELSE raise_application_error

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center