ORA-03113 : end of file on communication channel
401106Aug 10 2003 — edited Aug 11 2003My problem is I have created a new table in database it's structure is like __
SQL> desc cr_plblmst;
Name Null? Type
------------------------------- -------- ----
UNIT VARCHAR2(2)
AGCD VARCHAR2(5)
DPCD VARCHAR2(2)
NAME VARCHAR2(40)
ASTN VARCHAR2(40)
EDTN VARCHAR2(2)
LBLTY VARCHAR2(1)
ROUTE VARCHAR2(3)
SUBRT VARCHAR2(3)
PUCD VARCHAR2(2)
PUBL VARCHAR2(3)
RSUP NUMBER(6)
FRSUP NUMBER(6)
through sql prompt I am able to perfom any operation like query/insert/update/delete on this table.But Whenever I am attaching this table as a part of procedure in Report Designer and compiles the procedure it shows the following error_
ORA-03113 : end of file on communication channel.
further attempt of compiling it shows_
Error 201 identifier cr_plblmst must be declared.
Connecting the report to the database again it shows the same message again and again.
While other reports which are not using this table shows no error message while compiling and compilation completes successfuly.This error occurs only in report to which I am attaching this table(cr_plblmst) as a part of function or procedure.I have tried to create a new table with the same structure but the problem still exists.
Kindly suggest me possible causes and solution
thanks
Vikas