ORA-01460: unimplemented or unreasonable conversion requested
- You are using an Oracle client that does not know the database characterset used (eg. AL32UTF8 or WE8ISO8859P15)
- The tool you are using is not configured for the databases version (check the supplier)
- The client NLS_LANG does not match the database NLS_LANG
For example, take this piece of php code:
$qry="select value from atable where name=:name"; $stmt=OCIParse($conn, $qry); OCIBindByname($stmt, ":name", $_GET['parameter'], 30); OCIExecute($stmt);When the value of the passed parameter is less than or equal to 30 characters, you will see no problem.
Then the length exceeds 30 characters, you will see this error, probably followed by one of the following errors if you don't die after the bind failed: Either jump out of your program with the die statement, or limit the length of the passed parameter:
OCIBindByname($stmt, ":name", $_GET['parameter'], 30) or die 'Could not bind parameter';
Welcome to our forum for Oracle error: ORA-01460 Add your own message
i am getting problem while storing BLOB data in to database
'ORA 1460 - unimplemented or unreasonable conversion requested
any one know the solutions.
i am getting problem while storing BLOB data in to database
'ORA 1460 - unimplemented or unreasonable conversion requested
any one know the solutions.
Can you please post the code you are using to insert the blob.
Probaby there is an incorrect syntax used, or the logic is incorrect
I have clob as one of the datatype of one field in my table. I am storing complete XML file in this field. When XML file is too large such as more than 40,000 characters it truncates the character while saving XML file in the oracle database. The complete XML file is not saved. Please let me know the solution for the problem.
vibhu,
I am having the same problem. Did you find any solution for this?
Hi,
I am having problem with inserting blob data into oracle database. I get the following error: "ORA-01460: unimplemented or unreasonable conversion requested", when I try to import .tif or .jpg files. For .pdf and .txt files is fine.
The same code when is used from another PC, works hust fine. Can someone give me a hint how to solve the problem?
Are both pc's running the same version of the Oracle client, or is there a difference.
It might be a known problem of one of the Oracle client installations and or other technologies you use such as ODP.NET, ODBC, ...
The both PCs are having same version of Oracle client instalation, and same ODP.NET drivers.
An I guess the column is of type BLOB and not CLOB.
i.e. maybe you just tried to insert a text file from the working computer instead of an image, ...?
Did you try to use the same file? Maybe it's because of length restrictions
Yes, the column in the database is BLOB., and we both use the same database on server.
We tried with the same file, and it is a small image, around 150KB.
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.