Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Wierd Oracle 9 Behaviour -- Reserved Word?

Wierd Oracle 9 Behaviour -- Reserved Word?

From: Mac Flores IV <macflores_at_northwestern.edu>
Date: Thu, 25 Apr 2002 19:27:10 -0500
Message-ID: <3CC89EDE.C3E51752@northwestern.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US