ORA-01460: unimplemented or unreasonable conversion requested

[juba78]

Hi,

I've 2 oracle databases on different unix servers.
On database 1 , i run a procedure successflly.
On databsae 2 (same date, same table, same procedure) ,
i run the same procedure and it failed with this error :

ORA-01460: unimplemented or unreasonable conversion requested

The procedure use UTL_RAW.CAST_TO_VARCHAR2 to convert long raw.

I don't understand why it failed.
It's the same date, same table,same procedure i used.

Someone can i help me ?
Maybe there are something different between the 2 databases (memory,... ) ?
How can i compare the 2 databases ?


Thank for your help

 

[Thargy]

juba,

are the character sets of the two databases the same?



Regards

T

 

[juba78]

I've done
select * from NLS_DATABASE_PARAMETERS
and i've the same thing for the 2 databases

 

[karluk]

I suggest that you not allow yourself to be led astray by the fact that you have one database where your stored procedure is working. That's nice to know, and may even help in debugging down the road, but right now your task is to pinpoint what's causing the ORA-01460 error on the other database. You speculate that it's because of the call to UTL_RAW.CAST_TO_VARCHAR2, but do you know for sure? The ORA-01460 should give you a line number within the procedure where the error occurred. Please post the whole text of the error including the line number and also the code within the procedure that is executing when you get the error. If you also know other helpful information, such as table structures, please post that as well.