| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Inconsistency in SQL syntax, and ORA-3113 and ORA-1041 errors
A copy of this was sent to "Mark Greaves" <mgreaves_at_berger.com>
(if that email address didn't require changing)
On Thu, 28 May 1998 13:11:03 -0600, you wrote:
>This is really a two part question. I am running Oracle 8.0.4.0.0 under Sun
>OS 5.5.1.
>
[snip]
>My second question is related to the above. When I mistakenly keyed in the
>second query with the "IS" keyword,
>
> SELECT * FROM emp WHERE ename IS NOT LIKE 'S%';
>
>I get the error message
>
> ORA-03113: end-of-file on communication channel
>
>Then, if I enter any other query (legitimate or not), I get the message
>
> ORA-01041: internal error. hostdef extension doesn't exist
>
>The action for ORA-01041 is "report as a bug." I did call Oracle Support
>and left a message (they were experiencing a "peak level of calls" - gee,
>when are they ever NOT experiencing a peak???), but haven't heard back yet.
>I wonder if this is a new bug to Oracle8.
>
I tested in 7.1, 7.2, 7.3, 8.0.3, 8.0.4. In the 7.x versions it correctly reported "Missing NULL keyword". In 8.x it failed as you described.
When support calls back, you can tell them you hit bug #676451 which I just opened on this issue.
>Any comments?
>
>Mark Greaves
>DBA Consultant
>Berger & Co.
>
>
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 28 1998 - 20:21:08 CDT
 |
 |