How to declare identifier 'FADOLIF'? [message #405656] |
Thu, 28 May 2009 23:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
virgo
Messages: 2 Registered: May 2009
|
Junior Member |
|
|
I was unable to compile report 'FAS420.rdf' with error :-
'Error 201 at line 4, column 9
identifier 'FADOLIF' must be declared.
Statement ignored'
Attempt to add 3 new columns in the report ie vendor_name, invoice_number and cheque_number but the overall total report will wrongly added.
Thanks and Regards
Zaharah
|
|
|
|
Re: How to declare identifier 'FADOLIF'? [message #405742 is a reply to message #405675] |
Fri, 29 May 2009 05:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
virgo
Messages: 2 Registered: May 2009
|
Junior Member |
|
|
Hi Littlefoot
I'm new to the oracle reports. Could you please help me? Currently I'm stuck at the function declaration in formula screen as follows :-
function D_LIFEFormula return VARCHAR2 is
begin
return (fadolif(:life, :adj_rate, :bonus_rate, :prod));
end;
This is from the existing oracle report FAS420.rdf.
Managed to find fadolif.pll in $AU_TOP/plsql dir but was unable to find fadolif.plx in the $AU_TOP/resource dir. Do I need to generate the library too?
Thanks and Regards
|
|
|
Re: How to declare identifier 'FADOLIF'? [message #405753 is a reply to message #405742] |
Fri, 29 May 2009 05:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It seems that FADOLIF is, actually, a function that returns a value which is then returned by report's function (the one whose code you have posted).
Quote: | Do I need to generate the library too?
| I guess that you might do that and see what happens.
|
|
|