1 2 Previous Next 16 Replies Latest reply: May 8, 2012 4:38 AM by 904945 RSS

    ORA-06502: PL/SQL: numeric or value error

    904945
      Hi All,

      New requirement has came so i have created some six new fields,thats done in the form page.
      .All are select list fields. Front end of the form works properly .
      When am trying to create a new record, record is getting created ,getting notification email also but in the report page(home page) am getting error like this.

      ORA-06502: PL/SQL: numeric or value error+


      I have added these six fields as six column in the parent table (varchar2 datatype).all the fields are nullable only.
      I have added these six fields in the select query of the report also.

      When I went to see the table, the newly created values are updated in the table, but not appearing in the front end. showing the below error

      ORA-06502: PL/SQL: numeric or value error

      why am getting this error??
      Please some one help to resolve this error.


      Many Thanks.
      -Ramya.
        • 1. Re: ORA-06502: PL/SQL: numeric or value error
          Prabodh
          ORA-06502: PL/SQL: numeric or value error means the receiving item/column is not big enough to hold the value it is being assigned.

          Check the sizes.

          Regards,
          • 2. Re: ORA-06502: PL/SQL: numeric or value error
            904945
            Hi Probadh,

            I have mentioned the column size as 1000 for each fields..DO i need to change any properties in the report attributes?

            still getting the same error!:(

            Thanks ,
            Ramya.
            • 3. Re: ORA-06502: PL/SQL: numeric or value error
              Prabodh
              Run your application in Debug mode and check the Debug report(s) of source as well as target page to find out where that error is coming from.

              Less likely to come from Report columns, unless they are updateable columns. Chances are it is some Page Item, may be even a hidden one.

              The debug report will pinpoint the origin.

              Regards,
              • 4. Re: ORA-06502: PL/SQL: numeric or value error
                hitgon
                Hi,

                find the example with error explanation
                http://www.techonthenet.com/oracle/errors/ora06502.php

                Regards
                Hitgon
                • 5. Re: ORA-06502: PL/SQL: numeric or value error
                  904945
                  Praboth,

                  I ran the application in debug mode and then try to create a new record again getting the same error in the same home page.
                  When i went to the backend and delete the newly created record,error will get disappear and i can able to view all the existing record.
                  How to find which page is causing the error,i didnt how to find out the error in debug mode:(

                  Thanks ,
                  Ramya.
                  • 6. Re: ORA-06502: PL/SQL: numeric or value error
                    904945
                    Pabodh,

                    While creating the record i didnt get any error but when receiving the updated values from the table,getting this kind of error.
                    Once i deleted the values in the table,i dont see any error in the front end.

                    Thanks ,
                    Ramya.
                    • 7. Re: ORA-06502: PL/SQL: numeric or value error
                      Prabodh
                      You enter Debug mode by clicking the Debug button in the Developer Tool bar at the bottom.
                      To its left is the View Debug button. Click that button to see the Debug report of the current page.
                      Change the page selectors/filters on Debug report page to see the other debug reports of the pages in the application.

                      Scroll down the Debug Error Reports and look for the Errors listed in it.

                      Regards,
                      • 8. Re: ORA-06502: PL/SQL: numeric or value error
                        904945
                        Prabodh,

                        Error is in page number 27,home page(report page) not in the form page.

                        When i click error its showing pl/sql numeric or value error only.

                        Do i need to change report attributes?
                        since all the newly created items are select list?
                        Do i need to set the size of report attributes?

                        Thanks,
                        Ramya.
                        • 9. Re: ORA-06502: PL/SQL: numeric or value error
                          Prabodh
                          Read a few lines before the line that shows the error.
                          It will tell you which computation, process , branch etc Apex was running when it encountered this error.

                          And if you cannot still figure out then paste about 10-15 lines before the error line, and including the error, here.

                          regards,
                          • 10. Re: ORA-06502: PL/SQL: numeric or value error
                            904945
                            prabodth,

                            AM getting like this when i click on the error tab in view debug mode,

                            ORA-06502: PL/SQL: numeric or value error nadhini 27 2 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 2 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            ORA-06502: PL/SQL: numeric or value error nadhini 27 4 hours ago
                            :(

                            Thanks ,
                            Ramya.
                            • 11. Re: ORA-06502: PL/SQL: numeric or value error
                              Prabodh
                              Maybe your are looking at the Error tab.
                              Click on the Debug tab in the Popup page that you get when you click View Debug.

                              Regards
                              • 12. Re: ORA-06502: PL/SQL: numeric or value error
                                904945
                                Prabodh,

                                This is wat you have mentioned above?

                                0.28301 0.00031 ...Do not run process "Default_Value_P27_GROUPBY", process point=BEFORE_HEADER, condition type=, when button pressed= 4
                                0.28332 0.00285 ...Process "Environment_Details_APP": PLSQL (BEFORE_HEADER) Begin IF :REQUEST = 'LOAD_APPLICATION' then SELECT MAP.RESV_ID ,MAP.START_DATE,MAP.END_DATE ,MAP.USAGE ,ASSET.ID ,ENV.APPL_ID,ENV.PROJ_ID,MAP.TEES_ENV_CONF,ENV.TEES_OWN_ID,(SELECT MAX(BCF.BUILD_ID) FROM BCF_BUILD_RQST BCF WHERE ASSET.ID=BCF.INSTALL_TO_EN 4
                                0.28617 0.00088 ...metadata, fetch item type settings 4
                                0.28705 0.00919 ...metadata, fetch items 4
                                0.29628 0.00413 Show page template header 4
                                0.30037 0.00030 Computation point: After Header 4
                                0.30066 0.00261 Processing point: After Header 4
                                0.30327 0.00028 Computation point: Before Box Body 4
                                0.30355 0.00042 Processing point: Before Box Body 4
                                0.30397 0.01312 Region: Environment Tracker 4
                                0.31709 0.00040 Region: Environmental Usage Module 4
                                0.31749 0.00327 Region: Environment Tracker 4
                                0.32075 0.00148 Region: Tracker Criteria 4
                                0.32224 0.03480 Item: APPLICATION NATIVE_SHUTTLE 4
                                0.35704 0.01791 Item: P27_ENV_LIST NATIVE_SHUTTLE 4
                                0.37495 0.00213 Item: P27_TRACKER_START NATIVE_DATE_PICKER 4
                                0.37708 0.00140 Item: P27_TRACKER_END NATIVE_DATE_PICKER 4
                                0.37847 0.00254 Item: P27_GROUP_BY NATIVE_RADIOGROUP 4
                                0.38101 0.00080 Item: P27_ENV_APPLY BUTTON 4
                                0.38181 0.00228 Region: Environment Details 4
                                0.38409 0.00363 Item: P27_RESV_ID NATIVE_DISPLAY_ONLY 4
                                0.38771 0.00461 Item: P27_PROJECT NATIVE_DISPLAY_ONLY 4
                                0.39232 0.00164 Item: P27_TEES_OWNER NATIVE_DISPLAY_ONLY 4
                                0.39396 0.01588 Item: P27_START_DATE NATIVE_DISPLAY_ONLY 4
                                0.40985 0.00176 Item: P27_END_DATE NATIVE_DISPLAY_ONLY 4
                                0.41160 0.00181 Item: P27_USAGE NATIVE_DISPLAY_ONLY 4
                                0.41341 0.00227 Item: P27_CONF NATIVE_DISPLAY_ONLY 4
                                0.41568 0.00177 Item: P27_ISID NATIVE_HIDDEN 4
                                0.41745 0.00176 Item: P27_BUILD_NO NATIVE_DISPLAY_ONLY 4
                                0.41921 0.00250 Item: P27_REQ_BY NATIVE_DISPLAY_ONLY 4
                                0.42171 0.00185 Item: P27_TEES_CMT NATIVE_DISPLAY_ONLY 4
                                0.42356 0.00032 Region: Environment Incident 4
                                0.42387 0.00029 Region: Issue Tracking Form 4
                                0.42416 0.00283 Region: Tasks 4
                                0.42699 0.00287 show report 4
                                0.42986 0.00035 determine column headings 4
                                0.43025 0.00172 parse query as: RMO 4
                                0.43193 0.00266 rows loop: 15 row(s) 4
                                0.43459 0.00170 Region: Build Control Form 4
                                0.43629 0.00368 show report 4
                                0.43997 0.00030 determine column headings 4
                                0.44027 0.00162 activate sort 4
                                0.44190 0.00140 parse query as: RMO 4
                                0.44330 0.00126 binding: ":P27_ENV_LIST"="P27_ENV_LIST" value="1:10:100:101:102:103:104:105:106:107:108:109:11:110:111:112:113:114:115:116:117:118:119:12:120:121:122:123:124:125:126:127:128:129:13:130:131:132:133:134:135:136:137:138:139:14:140:141:142:143:144:145:146:147:148:149:15:150:151:152:153:154:155:156:157:158:159:16:160:161:162:163:164:165:166:167:168:169:17:170:171:172:173:174:175:176:177:178:179:18:180:181:182:183:184:185:186:187:188:189:19:190:191:192:193:194:195:196:197:198:199:2:20:200:201:202:203:204:205:206:207:208:209:21:210:211:212:213:214:215:216:217:218:219:22:220:221:222:223:224:225:227:228:23:24:25:26:27:28:29:3:30:31:32:33:34:35:36:37:38:39:4:40:41:42:43:44:45:46:47:48:49:5:50:51:52:53:54:55:56:57:58:59:6:60:61:62:63:64:65:66:67:68:69:7:70:71:72:73:74:75:76:77:78:79:8:80:81:82:83:84:85:86:87:88:89:9:90:91:92:93:94:95:96:97:98:99" 4
                                0.44456 0.00092 print column headings 4
                                0.44548 0.00183 rows loop: 15 row(s) 4
                                0.44731 0.00077 report error: ORA-06502: PL/SQL: numeric or value error


                                thanks,
                                Ramya.
                                • 13. Re: ORA-06502: PL/SQL: numeric or value error
                                  Prabodh
                                  The clue is in this line
                                  0.44330 0.00126 binding: ":P27_ENV_LIST"="P27_ENV_LIST" 
                                  value="1:10:100:101:102:103:104:105:106:107:108:109:11:110:111:112:113:114:115:116:117:118:119:12:120:121:.......
                                  {code}
                                  
                                  P27_ENV_LIST is not big enough to store the value it is being assigned.
                                  
                                  Increase the size of the P27_ENV_LIST page Item, or restrict the size of the value that is being assigned to it.
                                  
                                  Regards,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                  • 14. Re: ORA-06502: PL/SQL: numeric or value error
                                    904945
                                    Pabodh,

                                    How to limit the size of this field,we can limit the size of column but this is different.

                                    Thanks & Regards,
                                    Ramya.
                                    1 2 Previous Next