Oracle Database Errors or Warnings from Error ORA-01721 to ORA-01743

SQLServerF1

 

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction
Cause: The USERENV(‘COMMITSCN’) function can only be used once in a transaction.
Action: Re-write the transactioin to use USERENV(‘COMMITSCN’) only once
ORA-01722: invalid number
Cause: The specified number was invalid.
Action: Specify a valid number.
ORA-01723: zero-length columns are not allowed

Cause: Columns with zero length were not allowed.
Action: Correct the use of the column.
ORA-01724: floating point precision is out of range (1 to 126)
Cause: The specified number had an invalid range.
Action: Use a floating point precision that is in the correct precision.
ORA-01725: USERENV(‘COMMITSCN’) not allowed here
Cause: The function USERENV(‘COMMITSCN’) is only allowed as a top-level expression in the VALUES clause of an INSERT statement, and on the right-hand side of an assignment in an UPDATE statement.

Action: Correct the use of the function.
ORA-01734: illegal parameters – EXTENT MIN higher than EXTENT MAX
Cause: A wrong value is specified for the parameter.
Action: Correct the parameter and reissue the statement.
ORA-01742: comment not terminated properly
Cause: The indicated comment or hint begun with the /* token did not have the terminating */.
Action: Properly terminate the comment or hint with a */.
ORA-01743: only pure functions can be indexed
Cause: The indexed function uses SYSDATE or the user environment.
Action: PL/SQL functions must be pure (RNDS, RNPS, WNDS, WNPS). SQL expressions must not use SYSDATE, USER, USERENV(), or anything else dependent on the session state. NLS-dependent functions are OK.

Above are list of Oracle Database Errors or Warnings from Error ORA-01721 to ORA-01743 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *