Pipelined Table Function: Encountered Error ORA-00600
242163Apr 5 2004 — edited Apr 8 2004Hi,
I encountered the following error.
=======================================================
CREATE FUNCTION getCode ( p_code VARCHAR2) RETURN CodeType.lookups_tab
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kokvxsql1], [], [], [], [], [], [],
[]
ORA-00955: name is already used by an existing object
CREATE FUNCTION getAllCodes RETURN CodeType.lookups_tab
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4814], [5], [0], [0], [], [], [],
[]
=======================================================
I do not know what have caused this error. It was working initially.
I am unable to create the function again, unless I change package name for the object type (i.e CodeType).
Any idea what will cause this error ?
Also, I realised that there are quite a few entries
in dba_objects. How should I go about knowing whether
a object type is in use, and how to clear them from dba_objects ?
SQL> select created, object_id, object_name from dba_objects
2 where owner='DBMANAGER'
3 and object_type='TYPE';
CREATED OBJECT_ID OBJECT_NAME
--------- --------- --------------------------------------------------------------------------------
29-MAR-04 38208 SYS_PLSQL_38205_24
29-MAR-04 38206 SYS_PLSQL_38205_9
29-MAR-04 38207 SYS_PLSQL_38205_DUMMY
29-MAR-04 38233 SYS_PLSQL_38209_75
29-MAR-04 38231 SYS_PLSQL_38209_9
29-MAR-04 38232 SYS_PLSQL_38209_DUMMY
Thanks a lot.