| ORA-01413 [message #163548] |
Fri, 17 March 2006 03:40  |
Praseeja
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
Hi,
I'm getting the following error
"Oracle Error :: ORA-01413
illegal value in packed decimal number buffer" when i'm running a pro cobol process.
|
|
|
|
|
|
| Re: ORA-01413 [message #163559 is a reply to message #163548] |
Fri, 17 March 2006 04:18  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
And what are we to infer from this? other than that you have an error
quote from documetation:
| Quote: |
ORA-01413 illegal value in packed decimal number buffer
Cause: The user buffer bound by the user as packed decimal number contained an illegal value.
Action: Use a legal value.
|
Please read the sticky on how to get a quick answer for your question, at the top of the topics list in this forum.
Jim
|
|
|
|
| Re: ORA-01413 [message #163583 is a reply to message #163559] |
Fri, 17 March 2006 06:07 |
Praseeja
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
I tried to give a message when the customer id's are selected using a select statement
At a point of time actual customer code 105756 is copied to a variable as 5756...
At this point this error message is displayed.
i dont know why the customer code 105756 is changed to 5756
|
|
|
|
| Re: ORA-01413 [message #163585 is a reply to message #163583] |
Fri, 17 March 2006 06:13 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
<gobsmacked>How on earth are we meant to know.</gobsmaked>
Seriously, how do we know what your code is doing?
If I sent you a question :
| Quote: |
Hi,
I have a function, when I put the value of 12345 into the parameter list, I get a value of "HGXc4rGt Bungle, George, Zippy" back, this is not what I want, can you tell me what's wrong
|
Would you be able to give any kind of answer? Did you even bother to read the sticky that I mentioned? Here is a link to it:
http://www.orafaq.com/forum/t/59966/68488/
Please, please read it an follow the guidelines.
Thanks
Jim
|
|
|
|
| Re: ORA-01413 [message #163646 is a reply to message #163583] |
Fri, 17 March 2006 12:27 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| Praseeja wrote on Fri, 17 March 2006 07:07 |
At a point of time actual customer code 105756 is copied to a variable as 5756...
|
Just get rid of the substr(customer_code,3)||'..' when you assign it to the variable.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
