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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Program units

Re: Program units

From: James A. Johnson <nimbus3_at_bellsouth.net>
Date: 1998/12/28
Message-ID: <3686E2C1.885FAB52@bellsouth.net>#1/1

As far as I know, you can only call them from the report they are written in. To make then accessible by all the tools, make it a stored procedure.

Scot Balfour wrote:

> If I write a program unit: function compute_tax (return number) using
> Oracle Reports, can I reference compute_tax in the query SELECT
> statement in the data model--or can program units only be called from
> formula columns, format triggers, etc.
>
> What guidelines should I follow about where to store functions that are
> used only by a single report. Do I make a client-side library? Thanks.
Received on Mon Dec 28 1998 - 00:00:00 CST

Original text of this message

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