Update problems

From: Johan Bernström <isk_jobe_at_isk.kth.se>
Date: Fri, 11 Feb 2000 18:39:09 -0000
Message-ID: <881hgg$l7d$1@news.kth.se>

I'm communicating with oracle 8i using jdbc.

The folowing statement works fine:
SELECT rolltyp FROM rolltyper WHERE rolltyp_id = 5;

But when I try:
UPDATE rolltyper SET rolltyp = 'soldat' WHERE rolltyp_id = 5;

I get the error message ORA - 00911. From the documentation: "Cause: Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored."

As the select statment works this message seems very strange to me. Could anybody give me a hint of where else to look for the problem. I'v tried all I could think of.

/ Johan Bernström Received on Fri Feb 11 2000 - 12:39:09 CST