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>...


>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.