Re: Using Packages in Oracle forms

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 10 May 1999 15:19:32 +0100
Message-ID: <s$uptAA0ruN3EwLQ@ahardy.demon.co.uk>

In article <3736C1E2.E634CDC7_at_knold.ballehs.dk>, Michael Holm <datb9812_at_knold.ballehs.dk> writes
>Hi
>
>Yes I have the pragma restrict_references in my package. My package is as
>follows:

I get the same results as you!

I have no idea why this happens. I use packages in the ORDER BY properties of blocks with no problems, but cannot do a query of the form 'SELECT mypackage.function FROM DUAL'.

I can see no references in Forms help where a stored function is referred to other than in the forms 'variable := package.function(param)' or 'package.procedure(param1, paramn)' and that variable could refer to an item in a block.

From the example you show, it would appear that 'my_date := akk.akkdato('monday 10 may 1999');' would work in your case?

Sorry,
--
Andy Hardy. PGP key available on request

Received on Mon May 10 1999 - 09:19:32 CDT