Home » SQL & PL/SQL » SQL & PL/SQL » Help needed urgent
Help needed urgent [message #36880] Mon, 31 December 2001 00:10 Go to next message
Kishore
Messages: 45
Registered: September 2000
Member
hi,
I am using a proc/c code to constantly poll a database.I am doing a lot of fetch and there is only single insert statement.i am getting an error message:

ORA-01461: can bind a LONG value only for insert into a LONG column

as soon as the program starts ecxecution after a fetch statement.Does this error has anything to do with fetch?
kindly help me.

----------------------------------------------------------------------
Re: Help needed urgent [message #36884 is a reply to message #36880] Mon, 31 December 2001 07:08 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
are u trying to insert/fetch long value into another datatype?

----------------------------------------------------------------------
Re: Help needed urgent [message #36889 is a reply to message #36880] Mon, 31 December 2001 18:15 Go to previous message
Kishore
Messages: 45
Registered: September 2000
Member
hi suresh
thanx for the immediate response.No there is not even a single column having Long datatype

----------------------------------------------------------------------
Previous Topic: UPPER returning doubles
Next Topic: LONG RAW Limitation
Goto Forum:
  


Current Time: Wed Apr 17 20:47:18 CDT 2024