This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes ORA-00600: internal error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "ORA-00600: internal error" Watch "ORA-00600: internal error" New topic
Author

ORA-00600: internal error

sudharshan tettu
Ranch Hand

Joined: Jul 17, 2006
Posts: 124
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

Joined: Sep 29, 2008
Posts: 12617

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

Joined: Jul 17, 2006
Posts: 124
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

Joined: Sep 29, 2008
Posts: 12617

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

Joined: Jul 17, 2006
Posts: 124
hi david
no luck with out the parenthesis too... its happening only only wild card search is performed..... am still looking for a clue.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-00600: internal error
 
Similar Threads
a problem about oracle
ORACLE JDBC ERROR ORA-00600
Tomcat and jdbc problem
error
JDBC connection using eclipse ide