Ora-21000 Error Number Argument To Raise
Contents |
ORA-01429 ORA-01480 ORA-01555 ORA-03237 ORA-04030 ORA-04031 ORA-04091 ORA-12154 ORA-21000 ORA-28009 ORA-28009 PLS-00222 ORA-21000:error number argument to raise_application_error is out of range Submitted error number argument to raise application error of -4091 is out of range by sreemen on Fri, 11/13/2009 - 18:24 ORA-21000:error number error number argument to raise application error of 20001 is out of range argument to raise_application_error is out of range ORA-21000:error number argument to raise_application_error of stringstring raise_application_error example is out of range Cause:An attempt was made to specify a number not in the allowed range. Action:Use an error number in the
Ora-06512: At
range of -20000 to -20999, inclusive. ORA-21000: "error number argument to raise_application_error of 0 is out of range": The PL/SQL RAISE_APPLICATION_ERROR procedure has been called with an error code of 0. The only valid error codes are 20000 to 20099. The usualy cause for a value sqlcode of 0 being used is that a program has failed to set amn error variable correctly, e.g. it has called an exception but not set the variable. Search Results Enter your keywords: Search the web Search www.ora-code.info View the results at Google, or enable JavaScript to view them here. User login Username: * Password: * Request new password Oracle Errors ORA-00001 ORA-00017 ORA-00018 ORA-00019 ORA-00020 ORA-00021 ORA-00022 ORA-00023 ORA-00024 ORA-00025 ORA-00026 ORA-00027 ORA-00028 ORA-00029 ORA-00030 ORA-00054 ORA-00055 ORA-00060 ORA-00257 ORA-00600 ORA-00604 ORA-00936 ORA-00997 ORA-01000 ORA-01422 ORA-01429 ORA-01480 ORA-01555 ORA-03237 ORA-04030 ORA-04031 ORA-04091 ORA-12154 ORA-21000 ORA-28009 ORA-28009 PLS-00222 Tip of the day Refer to asktom.oracle.com for oracle design and performance related topics Oracle Search Search the web Search www.ora-code.info Recent blog posts Checking and Adding Space to tablespace more Real Time Tariffic Feedjit Live Blog Stats '
Message Navigator E-mail to friend ORA-21000: error number argument to raise_application_error of -1722 is out of range [message #309551] Thu, 27 March 2008 17:59 basirana Messages: 25Registered: July 2006 Junior Member I am trying to write conflict resolution procedure. When I try to raise a conflict it is not handle properly. I went o dba_apply_error and see below message. ORA-21000: error number argument to raise_application_error of -1722 is out of range ORA-06512: http://ora-21000.ora-code.info/ at "TBL_COUNTRIES_PKG", line 106 ORA-06512: at line 1 ORA-01403: no data found CREATE OR REPLACE PACKAGE tbl_countries_pkg AS TYPE emsg_array IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER; PROCEDURE update_countries( message IN ANYDATA, error_stack_depth IN NUMBER, error_numbers IN DBMS_UTILITY.NUMBER_ARRAY, error_messages IN EMSG_ARRAY); END tbl_countries_pkg ; / CREATE OR REPLACE PACKAGE BODY tbl_countries_pkg AS PROCEDURE http://www.orafaq.com/forum/t/99725/ update_countries( message IN ANYDATA, error_stack_depth IN NUMBER, error_numbers IN DBMS_UTILITY.NUMBER_ARRAY, error_messages IN EMSG_ARRAY ) IS ad ANYDATA; lcr SYS.LCR$_ROW_RECORD; ret PLS_INTEGER; key COUNTRIES.COUNTRY%TYPE; new_time_stamp TIMESTAMP; db_row COUNTRIES%ROWTYPE; v_update varchar2(2) := 'Y'; key_column_missing EXCEPTION; PRAGMA EXCEPTION_INIT(key_column_missing, -20101); begin ----print old and new values of tbl_prder--- --- util_pkg.print_anydata(message); ----print old and new values of tbl_prder--- -- access the LCR. ret := message.getobject(lcr); /* ad := lcr.get_value('new','last_updated','n'); if( ad is not null) then -- error if null new_time_stamp := ad.accesstimestamp(); else RAISE_APPLICATION_ERROR(-20101, 'missing last_updated value'); end if; */ ad := lcr.get_value('old','modified_by'); if( ad is not null) then key := ad.accessVarchar2(); begin SELECT * into db_row from COUNTRIES where COUNTRY = key; -- error if row not found EXCEPTION WHEN NO_DATA_FOUND THEN -- catches all 'no data found' errors RAISE_APPLICATION_ERROR(SQLCODE, SQLERRM); end; if( v_update = 'Y' ) then --COUNTRY ad := lcr.get_value('old','country'); if (ad is not null) then lcr.set_value('old','country',ANYDATA.ConvertVarChar2(db_row.country)); end if; --DT_CREATED ad := lcr.get_value('old','dt_created'); if (ad is not null)
was called Cause: This message is raised when the https://docs.oracle.com/cd/A64702_01/doc/server.805/a58312/newch265.htm SKIP_ROW procedure is called. Action: This procedure http://viniciuspapadba.blogspot.com/2012/11/rman-ora-21000-error-number-argument-to.html should be called only within a trigger or a procedure called by a trigger. ORA-20000: application_specific_message Cause: The stored procedure RAISE_APPLICATION_ERROR was called, which causes this message to be error number generated. Action: Correct the problem as described in the message or contact the application administrator or database administrator for more information. ORA-21000: error number argument to RAISE_APPLICATION_ERROR of num is out of range, must be between error number argument -20000 and -20999, inclusive Cause: An attempt was made to specify a number not in the range of -20000 to -20999. Action: The valid range for user-specified error numbers is -20000 to -20999 inclusively. Do not specify numbers outside this range. ORA-21001: error number argument to raise_system_error of num is out of range Cause: An attempt was made to specify a number not in the range of -23300 to -24299, or -29300 to -29399, inclusive. Action: Use an error number in the range of -23300 to -24299, or -29300 to -29399, inclusive. Prev Top Next Copyright © 1997 Oracle Corporation. All Rights Reserved. Library Product Contents Index
executing command: SET COMMAND ID starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 11/25/2012 10:41:23 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of full resync command on default channel at 11/25/2012 10:41:23 ORA-21000: error number argument to raise_application_error of -29999 is out of range What I did: Connect into catalog user: sqlplus catalog/catalog@rmanprd Unregister database from catalog. SQL> EXECUTE dbms_rcvcat.unregisterdatabase (db_key, db_id); Where do I get db_key? In catalog user: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcviews013.htm Log into RMAN using target and catalog database. RMAN> register database; RMAN> backup database; Done working !! Thanks !! Posted by Vinicius Papa at 12:47 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Vinicius Papa Oracle Apps DBA / DBA ATG Vinicius Papa Possui especialização em DBA Oracle 10g pela Faculdade Veris IBTA e especialização Internacional como Apps DBA pela empresa na Índia, atualmente trabalha em São Paulo. Has specialization in Oracle DBA 10g by Veris IBTA (official training center ) and International Training by company in Hyderabad, India... Certifications:
Popular Posts Recovering Control File with RMAN Corrupting and Recovering Data Blocks Corrupted using RMAN How To Clear Caches - R12 EBS R12: Create Custom TOP with adsplice Restore Datafile Without Backup - Archivelog Mode ON. Recovery Catalog ORA-12154 TNS could not resolve the connect identifier specified - while compiling manually forms ORA-20001 during GATHER_SCHEMA_STATS. Primeiro Post / First Post Recover Datafile from Hot Backup - User Management - Part 2 Blog Archive ► 2013 (8) ► November (1) ► August (3) ► July (1) ► June (1) ► May (1) ► January (1) ▼ 2012 (22) ► December (3) ▼ November (2) RMAN: ORA-21000: error number argument to raise_ap... APPS: libzip.so: symbol errno, version GLIBC_2.0 ► October (6) ► September (1) ► August (2) ► May (3) ► April (1) ► March (4) ► 2011 (38) ► November (3) ► October (3) ► September (2) ► August (5) ► July (25) Follo