Home » SQL & PL/SQL » SQL & PL/SQL » error, if run from sql prompt
error, if run from sql prompt [message #37884] Tue, 05 March 2002 05:16 Go to next message
ron
Messages: 50
Registered: July 1999
Member
When I ran procedure from SQL prompt(form from windows)
I got this error.
=====
ORA-01858: a non-numeric character was found where a numeric was expected
=====

where as if I run from unix, it wont give ny error.

is this becuase of session param or ???

Report message to a moderator

Re: error, if run from sql prompt [message #37886 is a reply to message #37884] Tue, 05 March 2002 05:34 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
which line is exactly giving error. can u post that line and providing information about the variable used in that statement

Report message to a moderator

Previous Topic: Re: error from sql (win) prompt
Next Topic: Primary key and unique
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 18:26:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.