How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
SQLERRM Function → %TYPE Attribute UPDATE Statement
SQLERRM Function → The 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.
SQLERRM Option → The SQLERRM option contains the error message associated with the current error code. It identifies
Retrieving the Error Code and Error Message: SQLCODE and SQLERRM → In 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
Usage Notes → SQLERRM 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
GET_DETAILED_SQLERRM Function → This function retrieves the detailed SQLERRM of the last exception raised.
Related Topics → Exceptions, SQLERRM Function Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Example → truncation) 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;
Checking for Errors → … The OLAP DML provides two options, SQLCODE and SQLERRM, whose values reflect the SQLCODE and SQLERRM values set in the database.
PL/SQL Considerations → set to only 1. You should depend only on the sqlcode and sqlerrm components of the SQLCA after execution of a PL/SQL block.
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.
PLS-01903 : non-integer error number → Cause: SQLERRM() was called with a non-integer value. Action: Make sure SQLERRM() is called with an integer value.
SQLCODE Function → more information, see "Retrieving the Error Code and Error Message: SQLCODE and SQLERRM".
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
Example → , 'Failed to send mail due to the following error: ' || sqlerrm); END; Copyright © 2000, 2002 Oracle
Built-In Functions → Reference. 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
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:
Example → , myMgr); END IF; EXCEPTION WHEN OTHERS THEN errnum:= SQLCODE; errmsg:= SUBSTR(SQLERRM, 1, 200
Oracle Reserved Words → SMALLINT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE TABAUTH