| ORA-6502 pl/sql numeric or value error [message #144584] |
Thu, 27 October 2005 05:20  |
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
|
Member |
|
|
Hi all,
i am upgrading my database from 8th version to 9th version.
i am calling one package from D2K form.
its giving the following error
ORA-6502 pl/sql numeric or value error
and the line number where i am getting this error in package.
i am using one local variable in that line.
var nvarchar2(500);
first i was working fine.i didn't get any errors even with this package.
i changed my database from one system to another ,after this i am getting this error.
please can anyone sujjest how to rectify this.
i cann't change that variable size also.
thank u
supriya
|
|
|
|
| Re: ORA-6502 pl/sql numeric or value error [message #144589 is a reply to message #144584] |
Thu, 27 October 2005 05:37  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
You are using Byte semantics for the NVARCHAR2 length? And are you using a multibyte character set?
If the answer to both questions is yes, that's your problem. Increase the size of the variable or shorten the value.
No way around it. A let's say you have a character set that uses 2 bytes per character and you use Byte semantics, you can only store 500/2 bytes per character = 250 characters in your variable.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
