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

From: Boris Cecic <illustro_at_iridis.com>
Date: Mon, 19 Oct 1998 13:41:31 +0200
Message-ID: <362B256B.66A6E69D@iridis.com>

Hello !

I have an interesting problem and couldn't find solution for it.

I've put some application logic into stored packages, procedures & functions.
Some of my view-s are using functions stored in database. I cann't issue any grant on that views.

Example:

1.) Create simple stored function

   create or replace function test return number is

      retval number;
   begin

      retval := 10;
      return retval;

   end;

2.) Create simple view that uses this function

   create or replace view v_test
   as select * from user_tables
   where test = 10;

3.) Issue grant on created view to public

   grant all on v_test to public;

   In this point I get disconnected from Oracle with message    ERROR at line 1:
   ORA-03113 - end-of-file on communication channel

I'm using Oracle Workgroup Server version 7.3.3.0.0. for Windows NT.

Please help me if you can !

Boris Cecic
illustro d.o.o., Croatia
e-mail: illustro_at_iridis.com Received on Mon Oct 19 1998 - 06:41:31 CDT