Home » SQL & PL/SQL » SQL & PL/SQL » Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable
Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable [message #58] Wed, 09 January 2002 07:24 Go to next message
bhuvan
Messages: 9
Registered: January 2002
Junior Member
Hi all ...

If I am sending more than 2000 characters as one of my field in Stored
procedure ..
Then it is raising this error ...

So what to do ... I am using VC++ ,ADO and Oracle .....

if i send less than 2000 characters .. then probs...

Description: [[Oracle]][[ODBC]][[Ora]]ORA-01460: unimplemented or unreasonable
conversion requested

awaiting for ur reply ..

Thanks in advance...

Bhuvan
Re: Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable [message #60 is a reply to message #58] Wed, 09 January 2002 12:06 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
what datatype u declared in VC++ for parameter?
what is oracle procedure parameter datatype?

those 2 things are important to answer your question.
Re: Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable [message #66 is a reply to message #60] Thu, 10 January 2002 04:22 Go to previous message
bhuvan
Messages: 9
Registered: January 2002
Junior Member
in Vc++ i decalred
CreateParameter("MessageBody",
advarchar,adParamInput,3000,strMessage).
In Oracle stored Procedure ..

VarMessage Varchar ..

so if i send more than 2000 characters it is giving that error .. so what to do..

Can u please give me a solution..

in oracle varchar will take only 2000 characters or what ?..

Bhuvan
Previous Topic: Dynamic SQLs
Next Topic: ole2 not declared
Goto Forum:
  


Current Time: Thu Mar 28 17:40:51 CDT 2024