Slashdot is powered by your submissions, so send in your scoop

 



Forgot your password?
typodupeerror
User Journal

Chacham's Journal: Verabiage: Michigan Talent Bank database bug. 2

Journal by Chacham

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.

This discussion has been archived. No new comments can be posted.

Verabiage: Michigan Talent Bank database bug.

Comments Filter:
  • Looks to me like the reponse of a (non-technical) customer service rep who has no idea what the error message means.
    • Looks to me like the reponse of a (non-technical) customer service rep who has no idea what the error message means.

      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.

When it is incorrect, it is, at least *authoritatively* incorrect. -- Hitchiker's Guide To The Galaxy

Working...