Ora-21000 Error Number Argument To Raise_application_error Of
Contents |
here for a quick overview of the site Help Center Detailed answers to any
Error Number Argument To Raise Application Error Of 20001 Is Out Of Range
questions you might have Meta Discuss the workings and policies of raise_application_error example this site About Us Learn more about Stack Overflow the company Business Learn more about hiring ora-06512: at developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Sqlcode
a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up raise_application_error of -4091 is out of range on UTL_SMTP.quit up vote 0 down vote favorite I am getting ORA-21000: error number argument to raise_application_error of -4091 is out of range on UTL_SMTP.quit(connection); I have SMTP related code in a procedure. so when I run below procedure it works fine. But when i call Send_Mail from a trigger in my application, it's throwing above mentioned error. BEGIN Send_Mail (p_to => 'temp@temp.com', p_from => 'temp@temp.com', p_message => 'Test message', p_smtp_host => 'tempserver' ); END; / Thanks for any help. plsql oracle11g share|improve this question asked Feb 11 '14 at 20:29 Venu 66313 add a comment| 1 Answer 1 active oldest votes up vote 4 down vote From the Oracle Documentation : Defining Your Own Error Messages (RAISE_APPLICATION_ERROR Procedure) The RAISE_APPLICATION_ERROR procedure lets you issue user-defined ORA-n error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions. To invoke RAISE_APPLICATION_ERROR, use the following syntax: raise_application_error( error_number, message[, {TRUE | FALSE}]); where error_number is a negative integer in the range -20000..-20999 and message is a character string up to 2048 bytes lo
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 by sreemen on Fri, 11/13/2009 - 18:24 ORA-21000:error number argument to raise_application_error is out of range ORA-21000:error number argument to raise_application_error of stringstring 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 http://stackoverflow.com/questions/21712358/raise-application-error-of-4091-is-out-of-range-on-utl-smtp-quit 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 http://ora-21000.ora-code.info/ 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 '
code with RAISE_APPLICATION_ERROR. The most common usage is: RAISE_APPLICATION_ERROR(code, message) Where code is an integer and message a string. Now, when the exception occurs, the user will see ORA-code: message. Sometimes you may http://groglogs.blogspot.com/2012/11/sql-oracle-ora-21000-error-number.html get the ORA-21000: error number argument to raise_application_error of X is out of range error. https://docs.oracle.com/cd/A64702_01/doc/server.805/a58312/newch265.htm This happens because, for user defined errors, the error code (first argument) MUST be between -20000 and -20999 included. From Stefano Ghio @ 20:24 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Tag: HowTo, Oracle, PL/SQL, Source code, SQL No comments: Post a Comment With great power comes great responsibility.Da grandi poteri derivano grandi responsabilità. Newer Post error number Older Post Home Subscribe to: Post Comments (Atom) Search Loading... Cheers Stefano Ghio Hmm... A rubber chicken with a pulley in the middle. What possible use could that have? View my complete profile Support my work Make a donation Tag HowTo (225) Source code (125) Linux (69) Oracle (58) Java (51) Pictures (43) Windows (37) SQL (36) Music (31) Web (31) Microsoft (30) TIBCO (23) PL/SQL (18) Spotfire (15) Ubuntu (15) error number argument Apache (13) Publications (12) Debian (7) OSGi (7) PHP (7) Eclipse (6) LUbuntu (6) Spring (6) Xfce (6) APT (5) GRUB (5) IronPython (5) LXDE (5) BusinessWorks (4) CentOS (4) Cryptography (4) Excel (4) Fedora (4) GNOME (4) Games (4) Python (4) VmWare (4) XUbuntu (4) Yum (4) Apple (3) GoogleChrome (3) JavaScript (3) Matlab (3) MySQL (3) Tomcat (3) VirtualBox (3) iPhone (3) ActiveSpaces (2) Android (2) Avaloq (2) BusinessEvents (2) FileZilla (2) HTML (2) MATE (2) PostgreSQL (2) Access (1) ApacheDS (1) DOS (1) EMS (1) HANA (1) Hibernate (1) JMS (1) Kodi (1) LDAP (1) Liferay (1) LightDM (1) MPlayer (1) OSIsoft (1) OpenSSH (1) PulseAudio (1) RPM (1) Remmina (1) SAP (1) SFTP (1) SSL (1) Suse (1) TOAD (1) VLC (1) Vim (1) Visual Basic (1) WineHQ (1) Wireshark (1) xterm (1) Archive ► 2016 (35) October 2016 (6) September 2016 (1) August 2016 (4) July 2016 (8) June 2016 (1) May 2016 (2) April 2016 (8) March 2016 (4) February 2016 (1) ► 2015 (51) December 2015 (6) November 2015 (5) September 2015 (2) August 2015 (7) July 2015 (4) June 2015 (4) May 2015 (2) April 2015 (3) March 2015 (4) February 2015 (3) January 2015 (11) ► 2014 (76) November 2014 (8) October 2014 (8)
was called Cause: This message is raised when the SKIP_ROW procedure is called. Action: This procedure 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 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 -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