Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03113 : end of file on communication channel

401106Aug 10 2003 — edited Aug 11 2003
My 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2003
Added on Aug 10 2003
4 comments
478 views