Error APP-IEX-240781:A cash receipt could not be created because of ORA-6502: PL/SQL: numeric or value error: NULL index table key value in Package IBY_FNDCPT_TRXN_PUB Procedure Create_Authorization. Authorization of credit card transaction failed The log correctly show COMMUNICATION_ERROR, an...
ALTER SYSTEM SET EVENTS '6502 TRACE NAME ERRORSTACK LEVEL 3'; This event trace can also be enabled at the session level. Enable the trace at the session level if the error can be reproduced by running the failing PL/SQL code from a SQL*Plus session.When enabling the trace at session le...
导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502 报错信息如下: [oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.log Export: Release 11.2.0.3.0 - Production on Sun Sep 28 13:40:59 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All r...
PL/SQL - Version 9.2.0.8 to 11.2.0.2 [Release 9.2 to 11.2]: Ora-6502 Hex To Raw Conversion Error - Backout Event Switch to disable the fix for 200446 not effective
导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502 报错信息如下: [oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.log Export: Release 11.2.0.3.0 - Production on Sun Sep 28 13:40:59 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All ...
APP-FND-01564: ORACLE error 6502 in afscpcon Cause: afscpcon failed due to ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 325 ORA-06512: at "SYS.HTP", line 1322 ORA-06512: at "SYS.HTP", line 1397 ...
APP-FND-01564: ORACLE error 6502 in afscpcon Cause: afscpcon failed due to ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 325 ORA-06512: at "SYS.HTP", line 1322 ORA-06512: at "SYS.HTP", line 1397 ...
怀疑是变量长度不够造成的问题。把str、str2、cnum的长度修改一下，字符串改为32767，这个是最大的长度，number不限定长度，修改如下：Str VARCHAR2(32767); --最终拼的字符串 Str2 VARCHAR2(32767); --最终拼的字符串 Ndate VARCHAR2(64); --当天日期 Cnum NUMBER; --当天的条数 ...
📷 SQL> create table t_book(bookid varchar2(3),bookname varchar2(50),publish varchar2(50)...