[nycphp-talk] PEAR::DB and Oracle insert error
Daniel Convissor
danielc at analysisandsolutions.com
Mon Mar 29 15:06:52 EST 2004
Hi Chris:
On Mon, Mar 29, 2004 at 09:28:27AM -0800, Chris Hubbard wrote:
> [nativecode=ORA-00911: invalid character]
ORA-00911 invalid character
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.
Action: Remove the invalid character from the statement or enclose
the object name in double quotation marks.
Maybe, try getting rid of the quote marks around the field names. I'd
also advise not using quoted identifiers in general, they cause more
headaches than they solve.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
More information about the talk
mailing list