This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi all, the Company I work for bought (at least) Mindscape version 3.0. The registered user is SLF. Unfortunately I have a problem... First of all, we're working on Oracle 10g with a legacy database. In this Db there is a table called FT_ASSET. When I try to perform a Find<FtAsset> using the Query class for many records the result is correct. Also if no records are found everything goes well. But in some cases, an Exception is generated:
ORA-01460: unimplemented or unreasonable conversion requested ORA-06512: at line 3 I attached the table CREATE as a txt, plus the export of samples, some working and some returning the exception... Plus, there is the query generated by LS. In addition I added the .cs model. Could you, please, tell me why this error and how to solve it? Thanks in advance CreF (Francesco) |
|
|
ORA-01460 usually indicates that Oracle is having some kind of problem converting between numeric types, date types or character types. My guess would be that there's some kind of issue with parameter conversion (i.e. one of the query parameters), but it could also be a problem with one of the data types that's coming back (you mentioned you never saw the exception if no records were returned). One possible issue may be with the CHAR types (e.g. ISHALB): I know sometimes Oracle insists on receiving CHAR(1)s as .NET Byte or Char parameters rather than as String parameters. Do you query on ISHALB or UTNOTIER? In order to diagnose this further, we would need to know which examples were working and which were returning the exception. You'll also want to turn on VerboseLogging so that you can see the parameter types. You should also try running the query directly using ADO.NET as this will tell you whether it is an Oracle issue or a LightSpeed issue (note that the "unreasonable conversion" is happening within Oracle, not within LightSpeed). |
|