NYCPHP Meetup

NYPHP.org

[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