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

SQL*Loader-00428: count for field string not stored in character or integer field

1 Answers  


SQL*Loader-00524: partial record found at end of datafile (string)

1 Answers  


DRG-10753: invalid memory size string string

1 Answers  


LPX-00272: FTP server unavailable: ~s

1 Answers  


PLS-01902: : hex to raw conversion error

1 Answers  






ORA-14508: specified VALIDATE INTO table not found

1 Answers  


ORA-22343: Compilation error for type invalidated by ALTER TYPE

1 Answers  


ORA-30382: DROP MATERIALIZED VIEW string.string operation is not complete

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


ORA-00087: command cannot be executed on remote instance

1 Answers  


ORA-22923: amount of data specified in streaming LOB write is 0

1 Answers  


ORA-01288: file string is from a different database incarnation

1 Answers  


Categories