Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pls_integer in my package ora-06502 pl/sql :numeric or value error

GolfStar03Sep 19 2011 — edited Sep 21 2011
i have a package that use of pls_integer AS you see in the follow

CREATE OR REPLACE PACKAGE BODY CLOB_HANDLER_PKG
IS


P$Size PLS_INTEGER := 8192 ;
.
.
part$p := SUBSTR( P$NClob, P$Pos, P$Size ) ;

this code is working fine in databaseA but in databaseB for some cases gives Exception ora-06502 pl/sql :numeric or value error when i change 8192 to 7192 it works correct .
what i must to do that this package works with 8192 in databaseB too?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2011
Added on Sep 19 2011
7 comments
494 views