Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pipelined Table Function: Encountered Error ORA-00600

242163Apr 5 2004 — edited Apr 8 2004
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2004
Added on Apr 5 2004
4 comments
3,493 views