ORA-01460: unimplemented or unreasonable conversion requested

Hi all, I am uploading a .doc file to a BLOB column: if I do the operation from a machine where I have oracle on it no issue...but if I do the operation from a machine where I dun have Oracle in it I get " ORA-01460: unimplemented or unreasonable conversion requested "

error

any help will be welcome

regards

jytrAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
It's a web application using straight ASP isn't it?

Can you provide an explanation of your architecture/applications/configuration?

I was assuming that your application is a web app using Microsoft ASP.
0
 
konektorCommented:
how do u upload the file ?
via C++ program using OCI library ?
via C++, VB, ... using ODBC ?
via java application using JDBC ?
if so check versions of OCI/ODBC/JDBC. versions released when latest version of oracle was Oracle 7.3 did not known BLOB datatype so cannot manipulate with it.
0
 
jytrAuthor Commented:
Hi konektor, I am using Oracle 9i
what happens is that the file seems uploaded to the db (I see the BLOB column poopulated with the value HugeBlob as I see any time the operation suceeds)...but I get that exception too...do u think on that basys the file is actually uploaded ?

Thanks and regards

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
Before you can get specific answers you will need to respond to konetor's request:  How are you loading the BLOB.

To check the length of a blob (to see if it is actually there):
select dbms_lob.getlength(<blob_column>) from <table>;

Check the byte count returned with the byte count of the file.
0
 
jytrAuthor Commented:
HI, I am uploading using asp ...checked and the lenght for the uploadings where I got an error is 0 (no value is extracted)

0
 
jytrAuthor Commented:
I am using an OleDb Connection to Oracle
0
 
slightwv (䄆 Netminder) Commented:
I'm confused:  
Are you using: select length(column)?  I would expect this error.....

To check the length of a lob you need to use the dbms_lob package that I described in my last post.

If I'm still not getting the issue:  Please provide some more a little more detail into the issue.

0
 
jytrAuthor Commented:
yes, I launched dbms_lob.getlength(<blob_column>) from <table>; to inspect the lenght of the BLOB column: I obteined as result a blank column (I used TOAD) do I deduceted there are no data in it
0
 
slightwv (䄆 Netminder) Commented:
I'm still confused:

What are you doing when you get: " ORA-01460: unimplemented or unreasonable conversion requested "
0
 
jytrAuthor Commented:
hi, I am uploading a document (.doc) into a BLOB column.
I repeat, all is ok if I do the operation from a machine (a machine where Oracle and the web server are in it) but if I try to do the operation from another machine (ie a machine where there no Oracle installed) I get that error...

any futher help is very appreciated as I am going in production next days...

D.
0
 
slightwv (䄆 Netminder) Commented:
I apologize for this but I'm still not getting it:

You have an ASP web page that allows for a user to upload a file.  You store this file in a BLOB in an Oracle DB running on machine 'A'.  

On machine 'B' you have ASP and the Oracle client installed:  Everything works.
On machine 'C' you have ASP and no Oracle client installed:  It doesn't work.

If the above is true, that is the problem.  Except for a few instances (ODBC), you must have the Oracle client installed to connect to an Oracle database.
0
 
jytrAuthor Commented:
OK, it makes sense...but so what I have to do to allow an user over the net to upload a file using my application ?

tnx and regards

D.
0
 
jytrAuthor Commented:
sure, I was missed a bit

:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.