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

ORA-13051: failed to initialize spatial object

1 Answers  


RMAN-20280: too many device types

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-24782: Cannot detach from a non-migratable transaction

1 Answers  


ORA-38950: Source platform string not cross platform compliant

1 Answers  






ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.

1 Answers  


PLS-00389: table, view or alias name "string" not allowed in this context

1 Answers  


ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices

1 Answers  


ORA-26057: Conversion is not necessary for this direct path stream.

1 Answers  


PCC-00039: Unable to open input file "string"

1 Answers  


LSX-00234: invalid decimal "~S"

1 Answers  


ORA-09750: pw_attachPorts: port_rename failed.

1 Answers  


Categories