Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Remotely executed package error

Remotely executed package error

From: Tad Davis <davist_at_umis.upenn.edu>
Date: 1997/02/19
Message-ID: <5ef7s3$6jf@netnews.upenn.edu>#1/1

We created a view that depends on the value of a package global variable. The package variable is set during package initialization. The idea was to do a complex lookup once per session and leave the resulting value in memory for the view's WHERE clause; this works much more efficiently than putting the lookup directly into the view. The approach works OK during host access. But when trying to access it remotely through a dblink, Oracle issues this message:

ORA-06574: Function GET_CURRENT_PERIOD references package state, cannot execute remotely

This message does not appear in my copy of the Server Messages and Codes Manual (December 1992). Can anyone explain this message in more detail, and is there any legitimate way around the problem?

--
Tad Davis                  215-898-7864 voice
(davist_at_isc.upenn.edu)     215-898-0386 fax
Received on Wed Feb 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US