Catch up on stories from the past week (and beyond) at the Slashdot story archive

 



Forgot your password?
typodupeerror
Get HideMyAss! VPN, PC Mag's Top 10 VPNs of 2016 for 55% off for a Limited Time ×
User Journal

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.

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.

"Morality is one thing. Ratings are everything." - A Network 23 executive on "Max Headroom"

Working...