Create Type Body Problem

From: <malcolm.chaires_at_intelsat.int>
Date: Wed, 25 Oct 2000 19:11:35 GMT
Message-ID: <8t7b8v$qn6$1@nnrp1.deja.com>

Whenever I issue a Create Or Replace Type Body statement (SQL*Plus), the parser seems to terminate the statement at the first semi-colon. All statements after that are not recognized. Example:

If I issue the following statement:

CREATE OR REPLACE TYPE BODY Customer_objtyp AS   ORDER MEMBER FUNCTION
  compareCustOrders (x IN Customer_objtyp) RETURN INTEGER IS   BEGIN
    RETURN CustNo - x.CustNo;
  END;
END;
/

This is what I get:

SQL> CREATE OR REPLACE TYPE BODY Customer_objtyp AS   2 ORDER MEMBER FUNCTION
  3 compareCustOrders (x IN Customer_objtyp) RETURN INTEGER IS   4 BEGIN
  5 RETURN CustNo - x.CustNo;

Operation 2013317271 succeeded.

SQL> END;
unknown command "END" - rest of line ignored. SQL> END;
unknown command "END" - rest of line ignored. SQL> / Operation 1239173 succeeded.

Anybody ever see anything like this before? Thanks to all who reply.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 14:11:35 CDT