PLS-801 or PLS-752 or PLS-707 Error While Executing a Pipelined Function (Doc ID 559786.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Mar-2013***


Symptoms

Executing a simple pipelined function like below fails with PLS-801 or PLS-752 or PLS-707 error.

Sample Program :

CREATE OR REPLACE PACKAGE pipe_parm_chk_pkg IS
  TYPE partition_rec IS RECORD 
    (column_value     varchar2(50));
  TYPE partition_rec_t IS TABLE OF partition_rec;
END;
/

CREATE or Replace FUNCTION f1 
 RETURN pipe_parm_chk_pkg.partition_rec_t 
 PIPELINED IS
 v_data pipe_parm_chk_pkg.partition_rec;
 
BEGIN 
      v_data.column_value  := 'cval';
      PIPE ROW(v_data);

  RETURN;
END;
/

 

Sample Output :

In 11.2


It fails when creating the function f1

CREATE or Replace FUNCTION f1
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

OR

CREATE or Replace FUNCTION f1
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [],
[], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [psdmsc.c: spawned type invalid],
[], [], [], [], [], [], [], [], [], [], []


In 11.1

SQL> SELECT * FROM TABLE(f1);
SELECT * FROM TABLE(f1)
*
ERROR at line 1:
ORA-06553: PLS-752: Table function F1 is in an inconsistent state.
ORA-00600: internal error code, arguments: [psdmsc.c: spawned type invalid],
[], [], [], [], [], [], [], [], [], [], []


In 10.2 

SQL> SELECT * FROM TABLE(f1); 
SELECT * FROM TABLE(f1) 

ERROR at line 1: 
ORA-06553: PLS-752: Table function F1 is in an inconsistent state. 

In 10.1 

SQL> SELECT * FROM TABLE(f1); 
SELECT * FROM TABLE(f1) 

ERROR at line 1: 
ORA-06552: PL/SQL: Compilation unit analysis terminated 
ORA-06553: PLS-801: internal error [hshuid:LU invalid]


In 9.2

SQL> SELECT * FROM TABLE(f1);
SELECT * FROM TABLE(f1)
                    *
ERROR at line 1:
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-707: unsupported construct or internal error [2604]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms