On Error Ora 06502
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle ora-06502 character to number conversion error Scripts Ion Excel-DB Don Burleson Blog
Ora-06502 Character String Buffer Too Small
ORA-06502: PL/SQL: numeric or value error Oracle Database Tips by ora-06502: pl/sql: numeric or value error: null index table key value Burleson Consulting Question on error "ORA-06502: PL/SQL: numeric or value error": I created the function p_test but when I try to run it I get the following error: ERROR ora-06502: pl/sql: numeric or value error: number precision too large at line 1: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 323 ORA-06512: at "JUAN.TEST_IP", line 6 ORA-06512: at line 1. Answer: The docs note this on the ORA-06502 error: ORA-06502: PL/SQL: numeric or value error string Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt
Frm-40735 Ora-06502
is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2). Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints. Answer by Edward Stoever: does owa_util exist and do you have access to it? You can find out by describing owa_util SQL> desc sys.owa_util But it looks like you do have access to it, because you are getting an error on a specific line of that package, which means that you entered it. The OWA_UTIL.get_cgi_env function is made for web browser accessing dynamic web content served up through an web server. I don't think it will work with 6i forms. That is why I suggested you look at THIS web page. There is a java bean package created to get the IP address of the browser that is accessing a 6i form through a browser there. It says: Get
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this ora-06502 exception handling site About Us Learn more about Stack Overflow the company Business Learn ora-06502 unhandled exception more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Ora-22275
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Stored http://www.dba-oracle.com/t_ora_06502_pl_sql_numeric_value_error.htm Proc hitting ORA-06502: PL/SQL: numeric or value error up vote 0 down vote favorite I'm having a problem calling a stored procedure from OSB 11g thru JCA Adapter. The error I'm getting is: ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 The error is as short as it is without any appends behind the error description. It only happens in production environment http://stackoverflow.com/questions/25840561/stored-proc-hitting-ora-06502-pl-sql-numeric-or-value-error and there are no problems when I point the database to the UAT one. More surprisingly, it will work in production envrionement if one of the variables I pass in is less than 128 characters. (or else I will hit the error above). The stored procedure type and length are defined correctly. having the table column able to cope for 4000 characters. Both Oracle 9i DB sharing the same major minor build revision. The stored proc is located in a package. I extracted out and compared the stored proc from both DB environments using winmerge and it shows they mirror each other. Executing the stored procedure manually in production environment works, provides that I declare a big enough varchar size. I manage to simulate the ORA-06502 error by declaring a variable size lesser than the data length I'm passing in. I even went as far as capturing the network dump from both executions and found there are slightly differences. (Note: I'm reusing the same datasource and only change the ip and username in WLS and did a restart before each executions) When I point to production environment(the 1 having tro
or value error string Description: Many data type and definition problems generate this message, with multiple instances shown. Let's look http://logicalread.solarwinds.com/ora-06502-dr01/ at two different examples. Example 1: A constraint violation when setting a "Not Null" variable to null Transact-SQL declare w_string varchar2(3) not null :='NOT NULL FIELD'; begin w_string := ''; end; / ÖÖÖÖ declare * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 2 123456789101112 declarew_string varchar2(3) not null on error :='NOT NULL FIELD';beginw_string := '';end;/ÖÖÖÖdeclare*ERROR at line 1: ORA-06502: PL/SQL: numeric or value error:character string buffer too smallORA-06512: at line 2 Example 2: An error when assigning a value larger than the variable definition Transact-SQL declare w_number number(3); begin w_number := 9999; end; / ÖÖ... declare * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: ora-06502: pl/sql: numeric number precision too large ORA-06512: at line 4 123456789101112 declarew_number number(3);beginw_number := 9999;end;/ÖÖ...declare*ERROR at line 1:ORA-06502: PL/SQL: numeric or value error: number precision too largeORA-06512: at line 4 Potential reasons for this error An error occurred relating to arithmetic, numeric, string or conversion operations. For example, an attempt is made to assign an integer larger than 999 to a variable declared NUMBER(3), or a variable declared NOT NULL if an a user tries to assign the value NULL. How to fix this error Modify the data, how it is declared or the operations on it to eliminate violations. Tags: Error Messages, Errors Subscribe to LogicalRead ; Tags Error Messages Errors Follow Us Contribute articles Give feedback Contact us Home SQL Server Oracle DB2 Sybase VMware About SolarWinds Privacy Statement Terms of Use © 2016 SolarWinds Worldwide, LLC. All rights reserved. Subscribe to Newsletter Want more helpful tips, tricks and technical articles? Get LogicalRead delivered to you! Complete the form to get the latest content delivered to your inbox. Email Address First Name CLOSE