ORA-00604 error occurred at recursive SQL level string
Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables ).
Action: If the situation described in the next error on the stack can
ORA-00604 error occurred at recursive SQL level string
Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables ).
Action: If the situation described in the next error on the stack can
ORA-12547: TNS: lost contact error handling, ora-12547tns
Nothing left to worry about. Configure the oracle database to automatically restart with the system. Check the information and find that you need to configure/etc/oratab and rc. local. The $
Create or replace procedure Test (tab_name in varchar2)Cursor cur_ref_cons_info (tab_name varchar2) is select B. column_name from user_constraints A, user_cons_columns B whereA. table_name = tab_name and A. constraint_type = 'r' and B.
Oracle Developer is famous for its rapid data processing and development, and its exception handling mechanism is also relatively complete.
1. Advantages of exceptions
If no exception occursProgramCheck whether each command succeeds or fails,
Java. SQL. Batch Update Exception: ORA-12899
Recently, when I used the JDOM component to parse XML file data and store the data to the oracle database, the following error occurs:
Exception in thread "main" java.sql.BatchUpdateException: ORA-12899:
This is a problem I have encountered in practice, the RAC+DG architecture cuts the repository to the primary library, and the Srvctl manager does not have database information.For the database created by DBCA, the Srvctl contains information about
11g ASM Single Instance dbca error prcr-1006 crs-0259 prcr-1071
11g ASM dbca error prcr-1006 crs-0259 prcr-1071 When creating a single instance DB Using ASM, it appears when running DBCAPRCR-1006: Failed to add resource ora. orcl. db for orclPRCR-107
Prospect:1. Install the x86_64 version of the CentOS 7 system (or the corresponding version of Red Hat, etc.) to the GNOME Desktop edition.2. Download and install and activate Xmanager Enterprise 5 for connection access to Linux systems, data
7 error messages and exception handling7.1 Introduction of the exception(1) The handling of exceptions is divided into three steps:A Declaration exceptionB throws an exceptionC Handling Exceptions(2) Characteristics of the anomalyA Error Type:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.