Oracle-L: Pragma question

From: <Roland.Skoldblom_at_ica.se>
Date: Wed, 17 Apr 2002 03:58:19 -0800
Message-ID: <F001.004463E1.20020417035819@fatcity.com>

Hallo all you gurus.

I have some questions:

Why do some people use a call to a funcion in the create view statement

for instance
CREATE OR REPLACE VIEW PRODUCT_GROUP ( COMPANY_ID, SET_ID, COUNTRY_CODE, PRODUCT_GROUP_ID, PRODUCT_GROUP_NAME, ARTICLE_GROUP_ID ) AS SELECT

     HIERARKI.SELSKAP,
     HIERARKI.SETT_ID,


--   HIERARKI_TEKST.LANDKODE,

     47,
     HIERARKI.VGRP,


--   HIERARKI_TEKST.TEKST,

     Hierarchy.GetHierarchyText
     (
          HIERARKI.SETT_ID,
          HIERARKI.VGRP,
          HIERARKI.ART_GRP,
          47
     ),
     HIERARKI.ART_GRP
FROM
     RIK2.HIERARKI HIERARKI

The function says like this: PACKAGE Hierarchy AS

FUNCTION GetHierarchyText(inSETT_ID NUMBER, inVGRP NUMBER, inART_GRP NUMBER, inLANDKODE NUMBER) RETURN VARCHAR2;

PRAGMA RESTRICT_REFERENCES( GetHierarchyText, wnds );

END Hierarchy;

2: Question number two: What means Pragma Restrict References?

Please help me.

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 17 2002 - 06:58:19 CDT