×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ORA-01460: unimplemented or unreasonable conversion requested

ORA-01460: unimplemented or unreasonable conversion requested

ORA-01460: unimplemented or unreasonable conversion requested

(OP)
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 :

Quote:

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

RE: ORA-01460: unimplemented or unreasonable conversion requested

juba,

are the character sets of the two databases the same?

Regards

T

RE: ORA-01460: unimplemented or unreasonable conversion requested

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

RE: ORA-01460: unimplemented or unreasonable conversion requested

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close