Remote Function Call Problem

From: Geoffrey Stewart <geoffrey_stewart_at_uow.edu.au>
Date: Mon, 22 Nov 1999 16:19:59 +1100
Message-ID: <3838D27F.B53E6477@uow.edu.au>

Hello All

I am having a problem trying to use a remote function call, as this is the first Time I have attempted this my problem may be simply lack of experience in Such matters...

• BACKGROUND

  ---

  There are two databases on the same server, HRPROD and OHS. There exists a package of utlity functions & procedures on HRPROD called HR (with an alias called HRF). This package has had EXECUTE granted to PUBLIC on HRPROD.
  • SYSTEM INFO ------------------------ login: congeoff Password:********* Last login: ******************* Sun Microsystems Inc. SunOS 5.5.1 Generic May 1996

SQL*Plus: Release 3.3.3.0.0 - Production on Fri Nov 19 10:52:27 1999

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.3.0.0 - Production

• WHAT HAPPENED <Running on DB OHS>-----------------

SQL> @FGS254 SQL> CREATE OR REPLACE VIEW fg_occupancy_v AS

  2  SELECT          p.employee#,
  3                  p.job#,
  4                  p.first_commence,
  5                  p.occupancy_end_date,
  6                  p.position#,
  7                  p.occup_pos_title,
  8                  p.AWARD,
  9                  p.CLASSIFICATION,
 10                  p.STEP#,
 11                  p.pos_FRACTION,
 12                  p.emp_status,
 13                  p.total_hours,
 14                  p.avg_hours,
 15                  p.SALARY_WEEK,
 16                  p.SALARY_YEAR,
 17                  p.clevel
 18  FROM            sub_con_hda_view_at_hrprod p
 19  WHERE           p.occup_type =

hr.active_occupancy_at_hrprod(p.employee#,p.job #)
 20 /

View created.

SQL>
SQL> DROP PUBLIC SYNONYM fg_occupancy_v   2 /

Synonym dropped.

SQL>
SQL> CREATE PUBLIC SYNONYM fg_occupancy_v FOR fg_occupancy_v   2 /

Synonym created.

SQL>
SQL> GRANT SELECT ON fg_occupancy_v TO PUBLIC   2 /
GRANT SELECT ON fg_occupancy_v TO PUBLIC *
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL> Error accessing package DBMS_APPLICATION_INFO ERROR:
ORA-03114: not connected to ORACLE

---

For some reason attemtping to grant acccess to this remote function Causes my ORACLE session to terminate. If I comment out the call In the above declaration there is no problem.

Any comments, help or wry remarks would be greatly appreciated!

Cheers
Geoffrey Stewart Received on Sun Nov 21 1999 - 23:19:59 CST