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

ORA-38437: The ADT "string" may not contain any user methods.

1 Answers  


ORA-09793: szguns: length of user name is greater than buffer.

1 Answers  


ORA-31505: cannot alter or drop predefined change set

1 Answers  


ORA-16608: one or more sites have warnings

2 Answers  


ORA-24760: invalid isolation level flags

1 Answers  






RMAN-20032: checkpoint change# too low

1 Answers  


QSM-00751: the file string could not be opened for write access

1 Answers  


ORA-27032: failed to obtain file size limit

1 Answers  


ORA-09831: snyStartThread: failed to build the server port set.

1 Answers  


ORA-24168: rule string.string cannot have default evaluation context

1 Answers  


PLS-00246: PARAMETER STYLE is unsupported

1 Answers  


ORA-25228: timeout or end-of-fetch during message dequeue from string.string

1 Answers   HP,


Categories