Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01858: a non-numeric character was found where a numeric was expected
ORA-01858: a non-numeric character was found where a numeric was expected [message #231838] Wed, 18 April 2007 09:56 Go to next message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Respected Sir,

ORA-01858: a non-numeric character was found where a numeric was expected

I am having trigger in which i am inserting if count is zero else update based on id (i.e id is my input parameter)

when i pass this 'CHI/NJY/C17183'(varchar2 datatype)as id

i am getting the above said error which i was raised in exception part of my trigger with sqlcode using raise_application_error.

Why it is giving me the above said error.

Please provide me the solution for above problem

Sincerely,
Chandrasekhar B.S
Re: ORA-01858: a non-numeric character was found where a numeric was expected [message #231843 is a reply to message #231838] Wed, 18 April 2007 10:07 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
There is a a non-numeric character where a numeric character is expected

That's about all that one is able to tell without actually seeing the code of the trigger and the actual error message ( which maybe even incudes the line number that the error occurs in)

You could try to comment out the exception block in the trigger, and maybe then the error that is raised is clearer.
Re: ORA-01858: a non-numeric character was found where a numeric was expected [message #231850 is a reply to message #231843] Wed, 18 April 2007 10:23 Go to previous message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Dear Sir,

I got that and fix that error part.

Regards,
Chandrasekhar B.s.
Previous Topic: using API's in datafile conversion
Next Topic: 9i to 10g
Goto Forum:
  


Current Time: Sat Dec 03 16:31:15 CST 2016

Total time taken to generate the page: 0.07371 seconds