PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be
a numeric literal



PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal..

Answer / guest

Cause: The second argument passed to an EXCEPTION_INIT
pragma was something other than a numeric literal (a
variable, for example). The second argument must be a
numeric literal in the range -9999 .. -1 (excluding -100)
for Oracle errors or in the range -20000 .. -20999 for
user-defined errors.

Action: Replace the second argument with a valid error number.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00576: list_delegated: list all delegated domains in the region or subtree

1 Answers  


ORA-02804: Allocation of memory failed for log file name

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  


ORA-02251: subquery not allowed here

1 Answers  


DRG-50400: maximum number of fuzzy match candidates exceeded: string

1 Answers  






ORA-01061: cannot start up a V8 server using a V7 client application

1 Answers  


ORA-32331: type "string"."string" is incompatible with the master site

1 Answers  


RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?

1 Answers  


CLSR-00513: Message file is not found

1 Answers  


ORA-28002: the password will expire within string days

1 Answers  


ORA-25400: must replay fetch

1 Answers  


ORA-30555: global index partitioning key is an expression

1 Answers  


Categories