How can I solve ORA-00911: invalid character error?

by

The statement you’re executing is valid. The error seems to mean that Toad is including the trailing semicolon as part of the command, which does cause an ORA-00911 when it’s included as part of a statement – since it is a statement separator in the client, not part of the statement itself.

It may be the following commented-out line that is confusing Toad (as described here); or it might be because you’re trying to run everything as a single statement, in which case you can try to use the run script command (F9) instead of run statement (F5).

Just removing the commented-out line makes the problem go away, but if you also saw this with an actual commit then it’s likely to be that you’re using the wrong method to run the statements.

There is a bit more information about how Toad parses the semicolons in a comment on this related question, but I’m not familiar enough with Toad to go into more detail.

More Related Contents:

  1. How to create id with AUTO_INCREMENT on Oracle?
  2. When do I need to use a semicolon vs a slash in Oracle SQL?
  3. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  4. How to handle a single quote in Oracle SQL
  5. Select count(*) from multiple tables
  6. Fetch the rows which have the Max value for a column for each distinct value of another column
  7. REGEX to select nth value from a list, allowing for nulls
  8. SQL – How to select a row having a column with max value [duplicate]
  9. Oracle: loading a large xml file?
  10. IF EXISTS condition not working with PLSQL
  11. Group by alias (Oracle)
  12. Using pivot on multiple columns of an Oracle row
  13. Sleep function in ORACLE
  14. Solution to “cannot perform a DML operation inside a query”?
  15. Split comma separated values of a column in row, through Oracle SQL query
  16. oracle — Split multiple comma separated values in oracle table to multiple rows
  17. How to query a CLOB column in Oracle
  18. update columns values with column of another table based on condition [duplicate]
  19. how to select even records from a table in oracle?
  20. Oracle : select maximum value from different columns of the same row
  21. Split varchar into separate columns in Oracle
  22. Creating or simulating two dimensional arrays in PL/SQL
  23. Using Alias In When Portion of a Case Statement in Oracle SQL
  24. Oracle string aggregation
  25. How do I list all the columns in a table?
  26. oracle SQL how to remove time from date
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment