|call colum formula resume [message #202967]
||Mon, 13 November 2006 07:56
Registered: November 2006
i have a question from my report.
I need to call colum formula from other types of formula can support the report.
I have the next formula colum in the data model (is not in the data model group, group query):
function cambiaparam2Formula return Number is
-- parameter user.
this function changes a user parameter, this parameter is use to control a query (see the next post i wrote, is about it : http://www.orafaq.com/forum/t/71975/2/)
I need to call, use from other functions are contains in unit attached library and formula group.
There are the other functions:
function CF_1Formula return Number is
--call the unit function with parameters.
FUNCTION DAME_PARAM2(cod number) RETURN NUMBER IS
if (cod = 23) then
-- here to call (column formula -> cambiaparam2)
and the select....
from table where cod=34 and parametro2:=3;
Any idea to do this...
How to call a external functions in the data model, in the part of the query.....??
Thank very much.