create type

From: Hui-Mei <h0p2468_at_acs.tamu.edu>
Date: Tue, 1 Dec 1998 00:26:31 -0800
Message-ID: <74029h$k47$1_at_news.tamu.edu>



Hello,
Do I need an object option to use object in Personal Oracle8? This is what I have tried:
create type tool_ty as object (toolname varchar2(25)); This is what I got:
SQL> create type tool_ty as object
  2 (toolname varchar2(25));
  3
  4
  5
No error message, the SQL*plus just wouldn't take it. I thought that I might need a privilege to use object so I grant the privilege. It still does not work. Could anyone tell me what is wrong with it? Thank you.
H. Mei Received on Tue Dec 01 1998 - 09:26:31 CET

Original text of this message