You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SQLERRM


1 to 20 of 54 results. Previous page Prev  Next next page
Results per page:   20  | 40


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

SQLERRM Function%TYPE Attribute UPDATE Statement

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 50 of 52

SQLERRM FunctionThe function SQLERRM returns the error message associated with its error-number argument or, if the … argument is omitted, with the current value of SQLCODE. SQLERRM with no argument is meaningful only … in an exception handler. Outside a handler, SQLERRM with no argument always returns the message … normal, successful completion.

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Relational Tables, 7 of 7

SQLERRM OptionThe SQLERRM option contains the error message associated with the current error code. It identifies

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Retrieving the Error Code and Error Message: SQLCODE and SQLERRMIn an exception handler, you can use the built-in functions SQLCODE and SQLERRM to find out which … no data found, in which case SQLCODE returns +100. SQLERRM returns the corresponding error message … SQLERRM returns the message: User-Defined Exception. unless you used the pragma EXCEPTION_INIT to … number and SQLERRM

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 50 of 52

Usage NotesSQLERRM is especially useful in the OTHERS exception handler because it lets you identify which … internal exception was raised. You can pass an error number to SQLERRM, in which case SQLERRM returns … the message associated with that error number. The error number passed to SQLERRM should be negative … . Passing

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_HTTP, 2 of 2

GET_DETAILED_SQLERRM FunctionThis function retrieves the detailed SQLERRM of the last exception raised.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 49 of 52

Related TopicsExceptions, SQLERRM Function Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 50 of 52

Exampletruncation) is not raised when you assign the value of SQLERRM to my_sqlerrm: DECLARE my_sqlerrm … VARCHAR2(150);... BEGIN... EXCEPTION... WHEN OTHERS THEN my_sqlerrm:= SUBSTR(SQLERRM, 1, 150); INSERT INTO audits VALUES (my_sqlerrm,...); END;

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Relational Tables, 7 of 7

Checking for Errors… The OLAP DML provides two options, SQLCODE and SQLERRM, whose values reflect the SQLCODE and SQLERRM values set in the database.

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Handling Runtime Errors

PL/SQL Considerationsset to only 1. You should depend only on the sqlcode and sqlerrm components of the SQLCA after execution of a PL/SQL block.

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Error Handling and Diagnostics

PL/SQL Considerations, not the actual number of rows fetched. So, you should rely only on the SQLCODE and SQLERRM fields in the SQLCA after executing a PL/SQL block.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-01903 : non-integer error numberCause: SQLERRM() was called with a non-integer value. Action: Make sure SQLERRM() is called with an integer value.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 49 of 52

SQLCODE Functionmore information, see "Retrieving the Error Code and Error Message: SQLCODE and SQLERRM".

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded PL/SQL

SQLExtProcError()this function is executed. The message is from the structure sqlerrm in the SQLCA. For a discussion of … the structure of the SQLCA and sqlerrm, see "SQLCA Structure". Here is an example showing use of

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 3 of 3

Example, 'Failed to send mail due to the following error: ' || sqlerrm); END; Copyright © 2000, 2002 Oracle

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Built-In FunctionsReference. Except for the error-reporting functions SQLCODE and SQLERRM, you can use all the functions in … SQLCODE SQLERRM ABS ACOS ASIN ATAN ATAN2 BITAND CEIL COS COSH EXP FLOOR LN LOG MOD POWER ROUND SIGN SIN

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Handling FORALL Exceptions with the %BULK_EXCEPTIONS Attribute); dbms_output.put_line('Oracle error is ' || SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE)); END LOOP … -reporting function SQLERRM, which expects a negative number. Here is the output:

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_REF, 2 of 2

Example, myMgr); END IF; EXCEPTION WHEN OTHERS THEN errnum:= SQLCODE; errmsg:= SUBSTR(SQLERRM, 1, 200

Reference Guide, 9i Release 2 (9.2.0.2)

Data Types, Reserved Words, and Functions

Oracle Reserved WordsSMALLINT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE TABAUTH

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Error Handling and Diagnostics

Declaring the SQLCA) INIT(136), 2 SQLCODE FIXED BIN (31), 2 SQLERRM CHAR (70) VAR, 2 SQLERRP CHAR (8) INIT('SQLERRP