Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Wierd Oracle 9 Behaviour -- Reserved Word?
I have a form that submits to an Oracle 9 database table of column
varchar2[4000]. When I type the following text in a textarea served by
a ColdFusion-based web interface, it errors:
--start of text---
She feels fine in the mornings, and notes that the attacks begin after
her arrival at school. She has not experienced similar consistent
attacks in the past.
---end of text----
The error I get is
ODBC Error Code = S1000 (General error)
However, when I submit the same text in an Oracle 8.1.7 database table of column varchar2[4000], I don't get any errors. I tried to submit the 2 sentences a word at a time and the error started when I include the word "begin" in the submission. Thus, I changed the word "begin" to "start" as follows:
--start of text---
She feels fine in the mornings, and notes that the attacks start after
her arrival at school. She has not experienced similar consistent
attacks in the past.
---end of text----
Lo, and behold! No error! I also tried:
--start of text---
She feels fine in the mornings, and notes that the attacks_begin after
her arrival at school. She has not experienced similar consistent
attacks in the past.
---end of text----
This one does not error out. Here's another text that gives me an error on an Oracle 9 database but does not give an error in an Oracle 8.1.7 database:
--start of text---
The pain can last anywhere from minutes to the full day but usually
feels better by the end of the day. She is not bothered by exercise,
food usually makes her feel better, but spices complicate her symptoms.
---end of text----
Again when I replace the words "end of" with "end_of" like:
--start of text---
The pain can last anywhere from minutes to the full day but usually
feels better by the end_of the day. She is not bothered by exercise,
food usually makes her feel better, but spices complicate her symptoms.
---end of text----
I don't get any errors! This is really wierd! Can anybody enlighten me on what's happening here? Thanks!
Mac Flores IV
Northwestern University, Evanston, IL. USA
macflores_at_northwestern.edu
Received on Thu Apr 25 2002 - 19:27:10 CDT
![]() |
![]() |