| Error Identifier 'GET_PRECISION' must be declared [message #209249] |
Wed, 13 December 2006 23:26  |
runaway
Messages: 2
Registered: December 2006
|
Junior Member |
|
|
hi,
I'm seeing problem folowwing When open a report:
REP-0756:Warning: Unable to find PL/SQL library 'inv'.
Although I connected to Server database,
Then in 'Report Buider' I'm trying to run this Report(or compile) that be error above then see Error:
Identifier 'GET_PRECISION' must be declared. in function "F_IC_QUANTITYFormatTrigger".
function F_IC_QUANTITYFormatTrigger return boolean is
begin
GET_PRECISION(:P_qty_precision);
return (TRUE);
end;
note that: GET_PRECISION belong to library Inv.pll, I attached this library no suscess.
The present,I'm using Oracle9i.
Please help me!
|
|
|
|
|
|
| Re: Error Identifier 'GET_PRECISION' must be declared [message #209656 is a reply to message #209249] |
Sat, 16 December 2006 07:08  |
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
|
Senior Member |
|
|
Hi ,
You can open and compile pll files in report builder.
If you open a pll file in report builder, it will show you file under node PL/SQL Libraries. Recompile and save pll file and attach it again with report and do not save path when it asks. Copy pll file at same location where you have rep/rdf files. It should work.
Bye
Ashu
|
|
|
|
| Re: Error Identifier 'GET_PRECISION' must be declared [message #242664 is a reply to message #209656] |
Mon, 04 June 2007 10:47 |
mduduzi
Messages: 1
Registered: June 2007
Location: South Africa
|
Junior Member |
|
|
My PL/SQL Libraries node is empty and I would like to attach the pll files if only I knew where to find them.
I copied the report from the server to a client machine but have no idea where the pll files are on the server.
Any help would be appretiated
Kind regards
Mduduzi
|
|
|
|
|
|
 Re: Error Identifier 'GET_PRECISION' must be declared [message #467693 is a reply to message #209249] |
Mon, 26 July 2010 13:56 |
valdo
Messages: 1
Registered: July 2010
|
Junior Member |
|
|
Solução encontrada no Chamado da Oracle ID 337302.1:
Cause:
----------
The issue is caused by file inv.pll missing on client's PC under the path oracle/reports6i/BIN.
Solution:
------------
To implement the solution, please execute the following steps:
1. Copy from the distribution CD or get a copy from Oracle Support or check under $AU_TOP/plsql.
2. Copy the file inv.pll to your PC under the path oracle/reports6i/BIN
Por valdo: Nesse caso a pasta onde coloquei a INV.pll foi C:\orant\REPORT60
3. Try to open the reports again in Reports Builder.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
