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