ORA-00933: SQL command not properly ended

by

In .net, when we try to execute a single Oracle SQL statement with a semicolon at the end. The result will be an oracle error: ora-00911: invalid character. OK, you figure that one SQL statement doesn’t need the semicolon, but what about executing 2 SQL statement in one string for example:

Dim db As Database = DatabaseFactory.CreateDatabase("db")
Dim cmd As System.Data.Common.DbCommand
Dim sql As String = ""

sql = "DELETE FROM iphone_applications WHERE appid = 1; DELETE FROM iphone_applications WHERE appid = 2; "

cmd = db.GetSqlStringCommand(sql)
db.ExecuteNonQuery(cmd)

The code above will give you the same Oracle error: ora-00911: invalid character.

The solution to this problem is to wrap your 2 Oracle SQL statements with a BEGIN and END; syntax, for example:

sql = "BEGIN DELETE FROM iphone_applications WHERE appid = 1; DELETE FROM iphone_applications WHERE appid = 2; END;"

Courtesy: http://www.lazyasscoder.com/Article.aspx?id=89&title=ora-00911%3A+invalid+character+when+executing+multiple+Oracle+SQL+statements

More Related Contents:

  1. Update statement with inner join on Oracle
  2. Oracle Update Query using Join
  3. SQL Command not properly ended?
  4. How do I limit the number of rows returned by an Oracle query after ordering?
  5. When do I need to use a semicolon vs a slash in Oracle SQL?
  6. LISTAGG in Oracle to return distinct values
  7. Fetch the row which has the Max value for a column
  8. Oracle SQL: Update a table with data from another table
  9. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  10. Select count(*) from multiple tables
  11. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  12. REGEX to select nth value from a list, allowing for nulls
  13. Concatenate and group multiple rows in Oracle [duplicate]
  14. Difference between BYTE and CHAR in column datatypes
  15. SQL to generate a list of numbers from 1 to 100
  16. How to use BOOLEAN type in SELECT statement
  17. Call a stored procedure with another in Oracle
  18. How to show all privileges from a user in oracle?
  19. SQL – How to select a row having a column with max value [duplicate]
  20. create table with sequence.nextval in oracle [duplicate]
  21. Split comma separated values of a column in row, through Oracle SQL query
  22. oracle — Split multiple comma separated values in oracle table to multiple rows
  23. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  24. Oracle (Old?) Joins – A tool/script for conversion?
  25. Split varchar into separate columns in Oracle
  26. Update rows in one table with data from another table based on one column in each being equal
  27. Curious issue with Oracle UNION and ORDER BY
  28. Oracle: function based index selective uniqueness
  29. Update a table with data from another table
  30. Insert into from CTE

Leave a Comment