How to create type in Oracle8?

From: <hp_smith_at_my-dejanews.com>
Date: Fri, 17 Jul 1998 21:40:36 GMT
Message-ID: <6oogck$3i4$1@nnrp1.dejanews.com>

SQL*Plus: Release 8.0.3.0.0 - Production on Fri Jul 17 13:50:3 1998

Connected to:
Personal Oracle8 Release 8.0.3.0.0 - Production With the Partitioning option
PL/SQL Release 8.0.3.0.0 - Production

SQL> create type name_ty as object
  2 (first_name varchar2(25),
  3 middle_initial char(1),
  4 last_name varchar2(25));
  5

Oracle seems do not know the end of the creation and keeps ask more input. Any guru can give me two cents? Thanks.

Hope

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 17 1998 - 16:40:36 CDT