problem with oracle 8.0 and the string "end" please help!!!!

hi, i'm having a problem with ASP to Oracle 8.0. when i insert a string or a substring that contains "end" within it to the database, i would get an error.

for example,

"INSERT INTO table_1 (prod_id, prod_name) VALUES ('10001','end');"
"INSERT INTO table_1 (prod_id, prod_name) VALUES ('10001','this is the
ending');"
"INSERT INTO table_1 (prod_id, prod_name) VALUES ('10001','this is a new
trend');"

all three of the above would cause an error because i'm insert a substring of "end".

i didn't get this problem when i try inserting it manually with the oracle tools ("SQL net" <--not sure if that was the name").

i also didn't get this problem with oracle v7.0 or v7.3

now, i'm thinking it's an ODBC driver problem... the driver is the default from the version 8.0 package.

please help and advise.
thank you much in advance,
darren...
haodo_at_earthlink.net Received on Sat Nov 14 1998 - 21:14:03 CST