how to find out this complie error in oracle report

wasabi3689
wasabi3689 used Ask the Experts™
on
I have an oracle report. When I compile it, I got the following error

"get_precision not declared in this scope"...


How to fix this problem

I am using oracle 8i
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
It looks like you have a variable or function called get_precision that is referenced in a part of the code where it is not declared.

Can you post some code?

Author

Commented:
The oracle report has many functions and triggers. I can only post the error function pointed to

function F_pll_quantity_orderedFormatTr return boolean is
begin

get_precision(:P_qty_precision);  return (TRUE);
end;
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
You need to see where the function get_precision is declared and if it is 'visible' (in scope) to be called from  F_pll_quantity_orderedFormatTr.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
How and where to see if function get_precision is declared  in the report?

I google this error. It seems missing libary. I wonder if get_precision is oracle built-in function?

http://forums.oracle.com/forums/thread.jspa?threadID=722425
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I'm also Googling around and found an old function called getPrecision.  

http://download.oracle.com/docs/html/B10954_01/o4c00245.htm

Maybe it is what you are after?

I'm not an Oracle reports person so I'm not sure how to check where that function is declared.  I just know by the error message, it isn't in an area your function can see/address.

Author

Commented:
I changed it to the following

function F_pll_quantity_orderedFormatTr return boolean is
begin

getprecision(:P_qty_precision);  return (TRUE);
end;


But it still gives me the same error
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I didn't figure that was the fix since that reference was an old 9i one.

What documentation says get_precision is a valid function?  Again, I'm not a reports person so I'm doing a lot of speculation.

Author

Commented:
I don't know. I just google this error. It seems to me it's a built-in function, just missing libbary
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Can't help over what I've already posted.  Since you are already Googling for fixes, I'm out.

Hopefully another Expert will know how to fix this.

My last Google showed this but I'm sure you've already seen it:
http://www.orafaq.com/forum/t/73940/2/

Author

Commented:
Thank you for the link. I am seeing this comment too. That is the error I am guessing but not sure if this is.

I don't know how to find and add library Inv.pll
Did you checked in BIN path if the library is present ? Check in the folder where your Oracle Forms and reports are been installed.

If it is not there then you need to place it there and compile pll files in report builder,so that your report should not through this error.

Author

Commented:
A developer sent me the file inv.pll and I attached it to my report. It works

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial