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
Prev 
Error Messages
DS-299, Internal Error (others) - {0} → Cause: An unexpected internal error occurred. Action: Contact Oracle Customer Support Services.
PL/SQL and FIPS Messages (PLS)
PLS-00369 no choices may appear with choice OTHERS in an exception handler → Cause: A construct of the form: WHEN excep1 OR OTHERS => was encountered in the definition of an … exception handler. The OTHERS handler must appear by itself as the last exception handler in a block … . Action: Remove the identifier that appears with OTHERS or write a separate exception handler for that identifier.
PL/SQL and FIPS Messages (PLS)
PLS-00210 an OTHERS clause is required in this CASE statement → expression, an OTHERS clause must be provided as the last clause of the CASE statement. It is impossible … to cover all values of type INTEGER (or NUMBER), so an OTHERS clause is always required when the
ORA-00000 to ORA-00899
ORA-00323 Current log of thread string not useable and all others need archiving → Cause: An attempt to open the thread failed because it is necessary to switch redo generation to another online log, but all the other logs need to be archived before they can be used. Action: Archive the logs for the thread and then retry the open.
PL/SQL and FIPS Messages (PLS)
PLS-00370 OTHERS handler must be last among the exception handlers of a block → Cause: One or more exception handlers appear after an OTHERS handler. However, the OTHERS handler … not named specifically. Action: Move the OTHERS handler so that it follows all specific exception handlers.
interMedia Relational Interface Reference
Examples → ' || TO_CHAR(DBMS_LOB.GETLENGTH(img_attrib))); EXCEPTION WHEN OTHERS THEN RAISE; END; /
PL/SQL Language Elements, 49 of 52
Example → NUMBER; BEGIN... EXCEPTION WHEN OTHERS THEN my_sqlcode:= SQLCODE; INSERT INTO audits VALUES (my_sqlcode,...); END;
Navigator
Application SQL History → using (i.e., Instance Management, Schema Management, and others) against the selected database.
DBMS_RULE_ADM, 2 of 2
Parameters → others. If false, then the specified user or users granted the specified privilege cannot grant the system privilege to others.
Deployment Templates Concepts and Architecture
In some situations, you may benefit from using row subsetting with an assignment table. An assignment… → The product_information materialized view is populated with product information for the products that are stored in the warehouse located at the postal code specified with the p_code variable. Notice the p_code variable in the last line of the CREATE MATERIALIZED VIEW statement. With this flexibility, managers can easily control materialized view data sets by making simple changes to the inventories
PL/SQL Language Elements, 17 of 52
Keyword and Parameter Description → exception previously declared within the current scope. OTHERS This keyword stands for all the exceptions … not explicitly named in the exception-handling part of the block. The use of OTHERS is optional and … is allowed only as the last exception handler. You cannot include OTHERS in a list of exceptions
Common Methods for interMedia Object Types Reference Information
Examples → '); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END;
interMedia Relational Interface Reference
Examples → ); DBMS_OUTPUT.put_line('contentLength: ' || doc_contentLength ); EXCEPTION WHEN OTHERS THEN RAISE; END; /
interMedia Relational Interface Reference
Examples → (DBMS_LOB.GETLENGTH(vid_attrib))); EXCEPTION WHEN OTHERS THEN RAISE; END; /
Common Methods for interMedia Object Types Reference Information
Examples → OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
interMedia Relational Interface Reference
Examples → (DBMS_LOB.GETLENGTH(img_attrib))); UPDATE timg SET img=img_data, attributes=img_attrib WHERE N=1; COMMIT; EXCEPTION WHEN OTHERS THEN RAISE; END; /
PL/SQL Language Elements, 16 of 52
EXCEPTION_INIT Pragma → OTHERS handler. For more information, see "Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT".
Physical Design in Data Warehouses
Physical Design Structures → Dimensions Some of these structures require disk space. Others exist only in the data dictionary
ORDDoc Reference Information
Examples → ('ORDSourceExceptions.NULL_INPUT_VALUE caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
XML Parser for C
isSingleChar() → characters (like ASCII, ISO-8859, EBCDIC, and others), or multibyte characters (like UTF-8 or Unicode
ORDVideo Reference Information
Examples → ('ORDVideoExceptions.NULL_INPUT_VALUE caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
PL/SQL Language Elements, 31 of 52
Examples → , the NULL statement shows that no action is taken for unnamed exceptions: EXCEPTION... WHEN OTHERS
ORDAudio Reference Information
Examples → ('ORDAudioExceptions.AUDIO_PLUGIN_EXCEPTION caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
PL/SQL Language Elements, 50 of 52
Example → VARCHAR2(150);... BEGIN... EXCEPTION... WHEN OTHERS THEN my_sqlerrm:= SUBSTR(SQLERRM, 1, 150); INSERT INTO audits VALUES (my_sqlerrm,...); END;
interMedia Relational Interface Reference
Examples → (DBMS_LOB.GETLENGTH(doc_attrib))); EXCEPTION WHEN OTHERS THEN RAISE; END; /
Common Methods for interMedia Object Types Reference Information
Examples → DBMS_OUTPUT.put_line('ORDSourceExceptions.METHOD_NOT_SUPPORTED caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
ORDVideo Reference Information
Examples → false'); end if; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line('exception raised'); END; /
ORDVideo Reference Information
Examples → ); update TVID set vid = obj where N = 1; COMMIT; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line('exception raised'); END; /
interMedia Relational Interface Reference
Examples → (DBMS_LOB.GETLENGTH(aud_attrib))); EXCEPTION WHEN OTHERS THEN RAISE; END; /
Error Messages
WM_ERROR_76 insufficient privileges to grant 'string' → grant the privilege. A user needs to have been granted a privilege with the grant option to be able to grant it to others.
Package oracle.jms
grantQueuePrivilege(Session, String, String, boolean) → others Throws JMSException - if the privilege could not be granted
Common Methods for interMedia Object Types Reference Information
Examples → DBMS_OUTPUT.put_line('ORDSourceExceptions.METHOD_NOT_SUPPORTED caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
Handling PL/SQL Errors
Handling Raised PL/SQL Exceptions → sequence_of_statements2... WHEN OTHERS THEN -- optional handler sequence_of_statements3 END; To catch raised … OTHERS exception handler, which is always the last handler in a block or subprogram, acts as the handler … for all exceptions not named specifically. Thus, a block or subprogram can have only one OTHERS … handler. As
ORDDoc Reference Information
Examples → PLUGIN EXCEPTION caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; / Example … ORDSYS.ORDDocExceptions.DOC_PLUGIN_EXCEPTION THEN DBMS_OUTPUT.put_line('DOC PLUGIN EXCEPTION caught'); WHEN OTHERS THEN
DBMS_RULE_ADM, 2 of 2
Parameters → granted the specified privilege can grant this privilege to others. If false, then the specified … user or users granted the specified privilege cannot grant this privilege to others.
ORDAudio Reference Information
Examples → DBMS_OUTPUT.put_line('AUDIO PLUGIN EXCEPTION caught'); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('EXCEPTION caught'); END; /
ORDAudio Reference Information
Examples → OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
XSU for PL/SQL
XSU Exception Handling in PL/SQL → ); result:= DBMS_XMLQuery.getXML(queryCtx); exception when others then -- get the original exception
ORDDoc Reference Information
Examples → OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /
ORDAudio Reference Information
Examples → ('ORDAudioExceptions.METHOD_NOT_SUPPORTED caught'); WHEN OTHERS THEN DBMS_OUTPUT.put_line('EXCEPTION caught'); END; /