procedure or function in Invalid state
hsac1301Mar 21 2006 — edited Mar 22 2006I got the following error
Oracle/PLSQL: ORA-06575 Error : function CURRENCYBASE is in an invalid state
i have recompile the function again
SQL> ALTER FUNCTION CURRENCYBASE COMPILE;
Warning: Function altered with compilation errors.
Errors for FUNCTION CURRENCYBASE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
5/2 PLS-00311: the declaration of
"org.compiere.sqlj.Currency.base(java.math.BigDecimal,int,java.sq
l.Timestamp,int,int) return java.math.BigDecimal" is incomplete
or malformed
How can i rectify this?
Harinder Kaur