ORA–04092
cannot COMMIT or ROLLBACK in a trigger
Cause
A trigger attempted to COMMIT or ROLLBACK. This is not permitted.
Action
Rewrite the trigger so that COMMIT or ROLLBACK statements are not used.
Oracle7 Server Messages
2 – 271
04070–04099: Triggers
ORA–04093
references to columns of type LONG are not allowed in triggers
Cause
A trigger attempted to reference a LONG column in the triggering table.
Action
Do not reference the LONG column.
ORA–04094
table name is constraining, trigger may not modify it Cause
A trigger attempted to modify a table that was constraining for some referential constraint of a parent SQL statement.
Action
Rewrite the trigger so that it does not modify that table.
ORA–04095
trigger name already exists on another table, cannot replace Cause
An attempt was made to replace a trigger that exists on another table.
Action
Re–create the trigger on the other table using the CREATE OR REPLACE
TRIGGER statement.
ORA–04096
trigger name has a WHEN clause that is larger than 2K
Cause
A trigger’s WHEN clause is limited to 2K for dictionary storage reasons.
Action
Use a smaller WHEN clause. Note, the trigger body could perform the same limiting action as the WHEN clause.
ORA–04097
error while trying to keep trigger n ame
Cause
An error occurred while trying to keep a trigger pinned in the shared pool.
Action
Check the trigger for possible syntax errors.
2 – 272
Oracle7 Server Messages
04100–04499: MVS
04100–04499: MVS
See your operating system–specific Oracle documentation. For a listing of other Oracle manuals containing operating system–specific messages, see “Related Publications” in the Preface.
04500–04899: CMS
See your operating system–specific Oracle documentation. For a listing of other Oracle manuals containing operating system–specific messages, see “Related Publications” in the Preface.
04900–04929: ICL DRS6000
See your operating system–specific Oracle documentation. For a listing of other Oracle manuals containing operating system–specific messages, see “Related Publications” in the Preface.
05000–05899: Original Equipment Manufacturers
See your operating system–specific Oracle documentation. For a listing of other Oracle manuals containing operating system–specific messages, see “Related Publications” in the Preface.
06000–06429: SQL*Net
See Oracle Network Products Messages Manual for information on these error messages. For a listing of other Oracle manuals containing operating system–specific messages, see “Related Publications” in the Preface.
Oracle7 Server Messages
2 – 273
06430–06499: NCR System 3000
06430–06499: NCR System 3000
See Oracle7 Server for NCR System 3000 Installation and User’s Guide. For a listing of other Oracle manuals containing operating system–specific messages, see
“Related Publications” in the Preface.
06500–06599: PL/SQL
This section lists messages generated when Oracle detects a problem with PL/SQL code. These ORA– nnnnn messages are usually followed by PLS– nnnnn messages, which are listed in Chapter 3.
ORA–06500
PL/SQL: storage error
Cause
This is a rare internal error message. Memory has been exhausted or corrupted.
Action
Contact customer support.
ORA–06501
PL/SQL: internal error num, arguments [ num], [ num], [ num], [ num],
[ num], [ num]
Cause
This is an internal error message. An error has been detected in a PL/SQL program.
Action
Contact customer support.
ORA–06502
PL/SQL: numeric or value error
Cause
An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
ORA–06503
PL/SQL: Function returned without value
Cause
A call to a PL/SQL function completed, but no RETURN statement was executed.
Action