Hi, I'm somewhat new to Oracle (8i). I'm attempting to update a LONG
column on a single row. I keep getting the following error:
The following error has occurred:
ORA-00972: identifier is too long
when attempting to use the following UPDATE query:
UPDATE emailer SET QUOTE = "I realize you are ultra-busy. Who is your
most-trusted advisor, with whom I can discuss if YOURCOMPANY can reap
similar benefits, and see if OURCOMPANY can help with any of the projects
you're working on now? RSVP, thanks FIRSTNAME,ryan" WHERE type =
'callaction' AND name = 'advisor'
What am I doing wrong?
On a side note, some of the rows in the QUOTE column contain double-quotes.
Is updating these going to be a problem? Do I need to escape them first?
Thanks
