| Null varchar [message #36359] |
Tue, 20 November 2001 04:44  |
Chiarini David
Messages: 1
Registered: November 2001
|
Junior Member |
|
|
Hello, I am looking for a solution to this problem: I have a PL/SQL procedure that receive some parameters. One of this is a varchar and all the other are simple type of parameter: int, real and so on.
A C++ process call the procedure and everithing works for days (weeks sometimes) then the procedure begin to receive a (NaN) as content of this input varchar parameter.
I don't know the exact meaning of (NaN) but everithig restart well if I stop and restart the DB. It is not enought to stop the C++ processes so I think it depends from something that is accumulated inside the DB.
I am not able to find a starting point to explain this event.
Do you have an idea.
Thanks in advance.
----------------------------------------------------------------------
|
|
|
|
| Re: Null varchar [message #36362 is a reply to message #36359] |
Tue, 20 November 2001 05:44  |
Vijay
Messages: 116
Registered: September 1999
|
Senior Member |
|
|
This NaN is received through c++ programme.It's not a db problem.The problem lies in c++ ont in dB.
NaN - not a number,this ocurs while characters are involved in numerical calculation in c++ programme.
If it happens in Db you will get
ORA-01722: invalid number
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
