|
|
|
|
Re: ORA-00902: invalid datatype [message #224785 is a reply to message #224626] |
Thu, 15 March 2007 08:12   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
sireeshraju wrote on Wed, 14 March 2007 16:54 | Hi Joy,
This one i copied directly from Oracle Corporation Pl/sql Material.This is the way it has been given in there.They are creating a table based on an object.I think this can be done.Correct me if I am wrong?
|
Sorry, Sireeshraju, my mistake, the create table command is correct, but there must be something wrong with the creation of your TYPEs beforehand.
|
|
|
Re: ORA-00902: invalid datatype [message #225062 is a reply to message #224617] |
Fri, 16 March 2007 18:51   |
srinivasocp
Messages: 91 Registered: December 2005 Location: INDIA
|
Member |
|
|
CREATE TYPE Person AS OBJECT (
first_name VARCHAR2(15),
last_name VARCHAR2(15),
birthday DATE,
home_address Address,
phone_number VARCHAR2(15))
/
CREATE TABLE persons OF Person;
Even this is givng the error ORA-00902: invalid datatype.
I can't understand why?Can someone help me.
|
|
|
|
|
|
Re: ORA-00902: invalid datatype [message #225206 is a reply to message #225067] |
Mon, 19 March 2007 02:39   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
@Anacedent - Is that level of personal attack really neccessary?
I know I've made equally simple mistakes in the past, and I'm pretty sure that the same goes for most of the regular poster here.
|
|
|
|
Re: ORA-00902: invalid datatype [message #225309 is a reply to message #225277] |
Mon, 19 March 2007 11:47   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
seraphstream wrote on Mon, 19 March 2007 09:42 | A common reason for this error is that the user has COMPATIBILITY set to V6. This may be because they have it set in the script they are running, have it set in glogin.sql or login.sql or they are running SQL*PLus 3.0 (which only runs in V6 - or V5! - compatibility mode)
|
I am anxious to see the answer to this because I'll bet you can count on a single hand the number of sites that have compatibility set to V5 or V6. Didn't those versions get discontinued in the 1980's? I started on V5 in 1991, and at that time it was kind of outdated if I recall.
|
|
|
Re: ORA-00902: invalid datatype [message #225676 is a reply to message #225309] |
Tue, 20 March 2007 21:38  |
sireeshraju
Messages: 32 Registered: October 2005
|
Member |

|
|
HI anacedent
Quote: | If you can not debug simple SYNTAX errors (repeatedly), maybe you should go into a different field where you do not have to pay so much attention to details.
IMO, Object Oriented programming should NEVER, EVER be brought into an RDBMS by a novice; if ever by an expert.
It is like trying to mix oil & water. It takes a lot of energy to make them play nice together.
|
@anacedent -- Mind your words Mr.anacedent,It will definitely hurt others.IF you know the answer reply for that or else mind your work.I think moderator has to take some steps to avoid this kind of abuse from other users.Only moderator has the right to advice the members.
@moderator--Please take care that this kind of personal abuse on the level of technical ground will not happen in future.Guys like anacedent will definitely screw the whole purpose of this site.This site is to share knowledge for both novice and experts.
[Updated on: Tue, 20 March 2007 21:41] Report message to a moderator
|
|
|