ORA-03113: end-of-file on communication channel

[msuresh]

One of our vendor app is failing on the following statements:

SQL> create or replace TYPE VEH_OBJ AS OBJECT ( VEH_MASTER_ID VARCHAR2(7) );
2 /

Type created.

SQL> CREATE TYPE VEH_OBJ_VARRAY AS VARRAY (100) OF VEH_OBJ;
2 /

Type created.

SQL> @tar.sql
SQL> DECLARE
2 v_varray VEH_OBJ_VARRAY ;
3 BEGIN
4 SELECT CAST(MULTISET(SELECT '78' FROM DUAL)
5 AS VEH_OBJ_VARRAY )
6 INTO V_Varray
7 FROM dual ;
8 END ;
9 /
DECLARE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


It failed on a 9.0.1.4 and 9.2.0.1 versions but worked on an 8.1.7.4 database.

Any idea???

[slimdave]

Originally posted by msuresh
Any idea???

search the forum for "end-of-file on communication channel"

[Ghost_Writer]

What O/S are you running the database on?

[stmontgo]

could be bug 2360357

can you drop the type and then create it?

check bdump/udump for any ora 600's?

[engiri]

Network disconnection is the comman cause.
Check the listener service in the server.