[EMAIL PROTECTED] wrote:
Now I have, one another problem with sql syntaxe. I try to translate
my perl script from Mysql to Oracle, but when I excute this script I
have this kind of error
[Fri Mar 5 17:11:19 2004] Telagene_oracle_test.pl: DBD::Oracle::db
do failed: ORA-00911: invalid character (DBD ERROR: error possibly
near <*> indicator at char 12 in 'INSERT INTO
<*>`BIOEXP`.`genbank_telagene2` (ac_number,proteine_name,locus_id)
VALUES ('AB017100','143T_HUMAN','')') [for Statement "INSERT INTO
`BIOEXP`.`genbank_telagene2` (ac_number,proteine_name,locus_id)
VALUES ('AB017100','143T_HUMAN','')"] at Telagene_oracle_test.pl line
370, <FIC1> chunk 6.
I think that my insert syntaxe is not correct , could you help me
please
You are correct, the syntax is not correct. As pointed out by the error
message, (`) is not a valid character in Oracle SQL. You should use (")
to quote column names if the names are case sensitive or contain
otherwise illegal characters for column names. That's one of the
differences between MySQL and Oracle SQL.
--
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
