Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-00600: internal error

 
sudharshan tettu
Ranch Hand
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Am getting the below exception when application tries to execute a query in hibernate.

"ORA-00600: internal error code, arguments: [qctosop:like transform], [], [], [], [], [], [], []"

here is my query

select T.user , T.userId from UserTable T where T.jobStatus like ('ACTIVE') AND T.DeletedFlag = 0


it works fine when T.jobStatus like ('ACTIVE') , but when i give wild card
like this : T.jobStatus like ('ACTIV%')
search its throwing the above exception any idea ?

Thanks and regards
Sudharsanam TK
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://www.orafaq.com/wiki/ORA-00600

I'd try it without the parenthesis first. Also, try running it from Oracle itself. What does the generated SQL look like?
 
sudharshan tettu
Ranch Hand
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply

From sql developer the query is executing properly .....but when i test through the application its throwing the exception .
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So... answering the other questions might be helpful, and telling us whether or not it works w/o the parentheses. And I'd rather *you* told us whether or not the query works, rather than you telling us somebody *else* says the query works.
 
sudharshan tettu
Ranch Hand
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi david
no luck with out the parenthesis too... its happening only only wild card search is performed..... am still looking for a clue.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic