Oracle Standard Error Codes
Contents |
Error Handling" in Oracle Database PL/SQL Language Reference. See the end of this chapter for TimesTen-specific considerations. The following topics are oracle error codes and solution covered: Understanding exceptions Trapping exceptions Showing errors in ttIsql Differences in TimesTen:
Ora Errors And Solutions
exception handing and error behavior Understanding exceptions This section provides an overview of exceptions in PL/SQL programming, ora error 12154 covering the following topics: About exceptions Exception types About exceptions An exception is a PL/SQL error that is raised during program execution, either implicitly by TimesTen or explicitly by https://docs.oracle.com/cd/B28359_01/nav/lookup.htm?id=ERRMG your program. Handle an exception by trapping it with a handler or propagating it to the calling environment. For example, if your SELECT statement returns multiple rows, TimesTen returns an error (exception) at runtime. As the following example shows, you would see TimesTen error 8507, then the associated ORA error message. (ORA messages, originally defined for Oracle Database, are https://docs.oracle.com/cd/E11882_01/timesten.112/e21639/exceptions.htm similarly implemented by TimesTen.) Command> DECLARE > v_lname VARCHAR2 (15); > BEGIN > SELECT last_name INTO v_lname > FROM employees > WHERE first_name = 'John'; > DBMS_OUTPUT.PUT_LINE ('Last name is :' || v_lname); > END; > / 8507: ORA-01422: exact fetch returns more than requested number of rows 8507: ORA-06512: at line 4 The command failed. You can handle such exceptions in your PL/SQL block so that your program completes successfully. For example: Command> DECLARE > v_lname VARCHAR2 (15); > BEGIN > SELECT last_name INTO v_lname > FROM employees > WHERE first_name = 'John'; > DBMS_OUTPUT.PUT_LINE ('Last name is :' || v_lname); > EXCEPTION > WHEN TOO_MANY_ROWS THEN > DBMS_OUTPUT.PUT_LINE (' Your SELECT statement retrieved multiple > rows. Consider using a cursor.'); > END; > / Your SELECT statement retrieved multiple rows. Consider using a cursor. PL/SQL procedure successfully completed. Exception types There are three types of exceptions: Predefined exceptions are error conditions that are defined by PL/SQL. Non-predefined exceptions include any standard TimesTen errors. User-defined exceptions are exceptions specific to your applicatio
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development Exceptions" for more information. Format: https://docs.oracle.com/cd/A97688_16/toplink.903/b10068/errorcod.htm A description shown in the actual exception thrown. Cause: The most probable cause for the error. Action: Suggestions for resolving the error. Descriptor Exceptions (1 - 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 23 Oct 2016 17:53:09 GMT by s_wx1062 (squid/3.5.20)