-
Dear Sir,
Three of my packages are not getting compiled and they show errors. The errors are as follows:
Warning: Package Body altered with compilation errors.
Errors for PACKAGE BODY SYS.DBMS_REPCAT_RGT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1146/9 PL/SQL: Statement ignored
1147/36 PLS-00705: exception 'MISSING_OFFLINE_DIRPATH' used in expression
requiring return type
alter TYPE BODY CTXSYS.CATINDEXMETHODS compile
*
ERROR at line 1:
ORA-00922: missing or invalid option
Errors for PACKAGE BODY SYS.DBMS_REPCAT_RGT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1146/9 PL/SQL: Statement ignored
1147/36 PLS-00705: exception 'MISSING_OFFLINE_DIRPATH' used in expression
requiring return type
alter TYPE BODY CTXSYS.TEXTINDEXMETHODS compile
*
ERROR at line 1:
ORA-00922: missing or invalid option
Errors for PACKAGE BODY SYS.DBMS_REPCAT_RGT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1146/9 PL/SQL: Statement ignored
1147/36 PLS-00705: exception 'MISSING_OFFLINE_DIRPATH' used in expression
requiring return type
Kindly give ure suggestions,
Regards,
K.Diwakar
-
Hi Diwakar,
From what I see in
http://desktop.msfc.nasa.gov/oracle8.../ch4d.htm#4838
You need not add 'BODY' in your alter statement.
Check this out and let me know.
Thanks,
-Shyami
Example
----------------------------------------
CREATE TYPE data_t AS OBJECT
( year NUMBER,
MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER
);
CREATE TYPE BODY data_t IS
MEMBER FUNCTION prod (invent NUMBER) RETURN NUMBER IS
BEGIN
RETURN (year + invent);
END;
END;
ALTER TYPE data_t REPLACE AS OBJECT
( year NUMBER,
MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER,
MEMBER FUNCTION qtr(der_qtr DATE) RETURN CHAR
);
CREATE OR REPLACE TYPE BODY data_t IS
MEMBER FUNCTION prod (invent NUMBER) RETURN NUMBER IS
MEMBER FUNCTION qtr(der_qtr DATE) RETURN CHAR IS
BEGIN
RETURN (year + invent);
END;
BEGIN
RETURN 'FIRST';
END;
END;
---------------------------------
