te falta la barrita de dividir al final del DDL :
Código SQL:
Ver originalSQL*Plus: Release 8.0.5.0.0 - Production ON Jue Mar 7 13:06:55 2013
(c) Copyright 1999 Oracle Corporation. ALL rights reserved.
Conectado a:
Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
SQL> CREATE TYPE direccion_t AS OBJECT(
2 calle VARCHAR2(50),
3 colonia VARCHAR2(50),
4 entre_calles VARCHAR2(100));
5 /
Tipo creado.
SQL>