[program-l] Re: Oracle SQL question
- From: "Eileen Lafond" <Eileen.Lafond@xxxxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Jul 2009 12:26:39 -0700
I found out what the problem was. I had an extra value field which I deleted.
Then I cut back the size of the data in the text field to about 20 words and
ran it as a clob. It worked.
Then I changed it back to the 409 words and ran it and got the same error
message as before.
The error message follows:
ORA-00972: identifier is too long
Would the fact that there are ' in the data make a difference? If so, what
would be acceptable?
Thanks for any help,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
>>> "Pranav Lal" <pranav.lal@xxxxxxxxx> 7/27/2009 5:42 PM >>>
Wont the varchar data type help? Or, you could try using the clob data type.
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Eileen Lafond
Sent: Tuesday, July 28, 2009 4:04 AM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Oracle SQL question
Hi,
I am trying to create a table with a field that can hold around 410 words.
I defined the field as long, but the error message says that there is too
much data for the field. How do I code the field to make it so that it can
contain around 409 words?
I believe that I am using Oracle version 9.
Thanks for any assistance,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
