Journal Chacham's Journal: Verabiage: Michigan Talent Bank database bug. 2
Went to the Michigan Talent Bank to search for jobs. I typed in "oracle\", and got an error.
# ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50943: query token too long on line 1 on column 5 ORA-06512: at "MICHIGAN_TALENT_BANK.WEB_ORDERS_SEARCH", line 870 ORA-06512: at line 1
So, realizing my mistake, i followed the further message that said to email them, and i sent them the following
In the search details, i mistakenly put in a backslash at the end. "oracle\". I then received the following error.
Error Details:
# ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle
Text error: DRG-50943: query token too long on line 1 on column 5 ORA-06512:
at "MICHIGAN_TALENT_BANK.WEB_ORDERS_SEARCH", line 870 ORA-06512: at line 1--
This is easily corrected by armoring the text. REPLACE(text, '\', '\\').
So, what do i get as a response?
The system will not accept characters as part of the search criteria. Remove the slash and re-submit your search to eliminate the error message.
. Hmm...
They have a bug, and don't want to fix it. Is this now the time for exploit?
UDATE:
Just tried again.
Error Details:
# ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50900: text query parser error on line 1, column 101 DRG-50917: escape on at end of text query string ORA-06512: at "MICHIGAN_TALENT_BANK.WEB_ORDERS_SEARCH", line 870 ORA-06512: at line 1
. Looks like they got the error. I wonder why they don't fix it.
Who did you write to? (Score:2)
Re:Who did you write to? (Score:2)
Well, it said to send error messages to that address.
Being i told him what the error was, he obviously didn't realize that i tried it again without it.