how to find out this complie error in oracle report
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
"get_precision not declared in this scope"...
How to fix this problem
I am using oracle 8i
Last Comment
ASKER
The oracle report has many functions and triggers. I can only post the error function pointed to
function F_pll_quantity_orderedForm
begin
get_precision(:P_qty_preci
end;
function F_pll_quantity_orderedForm
begin
get_precision(:P_qty_preci
end;
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_orderedForm
ASKER
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
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
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.
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.
ASKER
I changed it to the following
function F_pll_quantity_orderedForm
begin
getprecision(:P_qty_precis
end;
But it still gives me the same error
function F_pll_quantity_orderedForm
begin
getprecision(:P_qty_precis
end;
But it still gives me the same error
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.
What documentation says get_precision is a valid function? Again, I'm not a reports person so I'm doing a lot of speculation.
ASKER
I don't know. I just google this error. It seems to me it's a built-in function, just missing libbary
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
I don't know how to find and add library Inv.pll
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
A developer sent me the file inv.pll and I attached it to my report. It works
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Can you post some code?