3 Replies Latest reply: Jan 22, 2014 3:29 AM by BluShadow RSS

    Error will creating function

    1007945

      Hi Team,

       

      I am getting error message while creating Function script as below..

       

      CREATE TYPE Book_t AS OBJECT
      ( name VARCHAR2(100),
        AUTHOR VARCHAR2(30),
        ABSTRACT VARCHAR2(1000));
        /
      CREATE TYPE BOOKSET_T AS TABLE OF BOOK_T;
        /
      CREATE TABLE Catalogs
      ( NAME VARCHAR2(30), 
        CAT CLOB);
        /
        
        CREATE or replace FUNCTION GetBooks(a CLOB) RETURN BookSet_t;
      

       

      Error message :=

      • Error(1): PLS-00378: invalid compilation unit for this release of PL/SQL

      But All object are valid state only.