Beta
×

Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!

Verabiage: Michigan Talent Bank database bug.

Chacham (981) writes | more than 10 years ago

User Journal 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

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.

cancel ×

2 comments

Sorry! There are no comments related to the filter you selected.

Who did you write to? (1)

turg (19864) | more than 10 years ago | (#9691481)

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

Re:Who did you write to? (1)

Chacham (981) | more than 10 years ago | (#9691876)

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.
Check for New Comments
Slashdot Login

Need an Account?

Forgot your password?

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>