Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01460 unimplemented or unreasonable conversion requested in odp.net

520139May 15 2007 — edited May 12 2011
Hi,

i have a problem with a select statement
we use odp.net Version 2.102.2.20
our database server version is
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

The problem is:
when i do a first select like this
begin open :Liste for select distinct(MA_ROLLE) from ap.benutzerrollen where MA_ROLLE like :ROLLE order by MA_ROLLE desc;end;
the variable :MA_ROLLE is a varchar(50) INPUT and the variable :Liste is a RefCursor
the value of the parameter is 'GA'
when after that i do a second select but the parameter value is longer than the previous one for example 'Tester' i receive the following error:
ORA-01460: unimplemented or unreasonable conversion requested.

Is it a known problem, is there a workaround?

thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2011
Added on May 15 2007
20 comments
70,811 views