Innocent SQL causes an imminent process death..

From: Unemployed in the Valley <rembus_at_mail.ru>
Date: 3 Oct 2002 11:03:31 -0700
Message-ID: <5ec5bf40.0210031003.2f3fd6a6@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. Received on Thu Oct 03 2002 - 13:03:31 CDT