Home » SQL & PL/SQL » SQL & PL/SQL » Null varchar
Null varchar [message #36359] Tue, 20 November 2001 04:44 Go to next message
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 Go to previous message
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

Previous Topic: Return Cursor problem
Next Topic: Dynamic SQL in stored procedures
Goto Forum:

Current Time: Sat Jun 12 15:04:01 CDT 2021