Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Innocent SQL causes an imminent process death..
I don't think I would call it a totally innocent SQL statement, but I created an empty table, executed the query, and got an ORA-03113 on 8.1.7.4.1, and an ORA-00600 on 9.2.0.1 with arguments [qctcte1],[0],[],[],[],[],[],[]
Pass it on to Oracle support.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA__________November 7/9 (Detroit) ____USA__________November 19/21 (Dallas) ____England______November 12/14 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Unemployed in the Valley wrote in message <5ec5bf40.0210031003.2f3fd6a6_at_posting.google.com>...Received on Thu Oct 03 2002 - 15:39:35 CDT
>I wonder if anyone ever encountered something like this:
>
>Environment - Oracle 8.1.6 on Solaris 2.8
>Table "relations" defines the node hierarchy.
>
>SQL> connect username/password_at_server
>Connected.
>SQL> desc relations;
> Name Null? Type
> ----------------------------------------- --------
>----------------------------
> REC_ID NOT NULL NUMBER
> PARENT_NODE_ID NOT NULL NUMBER
> CHILD_NODE_ID NOT NULL NUMBER
> CREATION_DATE NOT NULL DATE
>
>SQL> select count(*)
> 2 from relations
> 3 start with parent_node_id=3
> 4 connect by prior child_node_id=parent_node_id
> 5 and prior child_node_id in (select 3 from dual)
> 6 ;
> select count(*)
>*
>ERROR at line 1:
>ORA-03113: end-of-file on communication channel
>
>-----------------
>
>I tried it on 3 different servers with the same results from Windows &
>Solaris clients.