| call colum formula resume [message #202967] |
Mon, 13 November 2006 07:56 |
thepunisher_oracle
Messages: 3
Registered: November 2006
Location: spain
|
Junior Member |
|
|
hello,
i have a question from my report.
I need to call colum formula from other types of formula can support the report.
Example:
I have the next formula colum in the data model (is not in the data model group, group query):
function cambiaparam2Formula return Number is
variable number;
var2 number;
begin
variable:=0;
:parametro2:=2;
-- parameter user.
return variable;
end;
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:
(formula group)
function CF_1Formula return Number is
valor number;
begin
UnitParameter(:cod);
--call the unit function with parameters.
end;
(formula unit)
FUNCTION DAME_PARAM2(cod number) RETURN NUMBER IS
var number;
BEGIN
if (cod = 23) then
var:=2;
:parametro2:=3;
end if;
cambiaparam2;
-- here to call (column formula -> cambiaparam2)
END;
and the select....
select cod
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. 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
