Skip to Main Content

APEX

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!

The Bizarre 'ORA-01460: unimplemented or unreasonable conversion requested'

652474Aug 6 2008 — edited Aug 6 2008
The weirdest thing happened to me and my database yesterday. I have a few multiselect boxes to search with using the following code (ofcourse each different columns and what not):

(

(instr(':'||:P1_COMPANY_NAME ||':',':'||COMPANY_NAME||':') > 0 or :P1_COMPANY_NAME is null)

)

Everything was working fine, it was great. I was happy, no problems, nothing for ONCE. Then yesterday I tried selecting 4 companies and searcing, I get that ORA-01460 error. I can search up to 3 countries, any more then 3 will cause this error. What was even weirder, was that my Country multi-select box (using the exact same code as the one posted above) didn't even work at all. When I selected a country it said 'No Data Found'. Now I tried everything I could, I delected the page re-made it once again. Nothing has worked. The only thing I have changed since then was the datatype for the columns, I'm not sure if that would screw anything up?

I changed varchar to char for the company name and country. Please reference my other topic for more information: 691444

Any ideas on how to make this work, I have tried everything.

Oh yeah, and tips for anyone that has problems, never attempt to recreate a page. It is probably the worst experience in my entire life. lol

S.O.S. SEND HELP!

Sincerely,

Mike
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2008
Added on Aug 6 2008
11 comments
860 views