PLS-00700: PRAGMA EXCEPTION_INIT of string must follow
declaration of its exception in the same declarative part



PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same dec..

Answer / guest

Cause: An EXCEPTION_INIT pragma was not declared in the same
block as its exception. They must be declared in the proper
order in the same block, with the pragma declaration
following the exception declaration.

Action: Place the EXCEPTION_INIT pragma directly after the
exception declaration referenced by the pragma.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-01040: Data streams opened by server: number

1 Answers  


PCC-02449: Cannot type equivalence a UCS2 type

1 Answers  


ORA-02762: file number to be cancelled is greater than the maximum.

1 Answers  


ORA-13154: invalid precision specified

1 Answers  


QSM-02142: COUNT(*) is not present in the select list

1 Answers  






ORA-28233: double encryption not supported

1 Answers  


RMAN-08548: recovery area destination: string

1 Answers  


ORA-14008: missing THAN keyword

1 Answers  


ORA-16176: background dictionary build cannot be running

1 Answers  


ORA-30356: the specified refresh method is not supported in this context

1 Answers  


QSM-01070: equivalence class manager was not found

1 Answers  


ORA-00105: too many dispatcher configurations

1 Answers  


Categories