*
ORA-00911:*invalid character*Cause:*identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#...#') cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. Error: ORA-00911: invalid character Cause: You tried to tried to execute an SQL statement that included a special character. Action: The options to resolve this Oracle error are: 1. This error occurs when you try to use a special character in an SQL statement. If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations. 2. This error may occur if you've pasted your SQL into your editor from another program. Sometimes there are non-printable characters that may be present. In this case, you should try retyping your SQL statement and then re-execute it. 3. This error occurs when a special character is used in a WHERE clause<http://www.techonthenet.com/sql/where.php>and the value is not enclosed in single quotations. For example, if you had the following SQL statement: SELECT * FROM suppliers WHERE supplier_name = ?; You would receive the following error message: ORA-00911: invalid character You could correct this error by enclosing the ? in single quotations as follows:. SELECT * FROM suppliers WHERE supplier_name = '?'; >From the Oracle side, ORA-00911 happens, as explained above, because of an invalid char in statements. It is not an invalid symbol!. I hope that this help to isolate the error. A. C. Censi On Wed, Apr 1, 2009 at 11:52 AM, mdipierro <mdipie...@cs.depaul.edu> wrote: > ORA-00911 error (bad symbol!) > -- A. C. Censi accensi [em] gmail [ponto] com accensi [em] montreal [ponto] com [ponto] br --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
