SQL Error [911] [22019]: ORA-00911: invalid character

Note: please leave bug reports and feature requests on

SQL Error [911] [22019]: ORA-00911: invalid character

Postby Paizo » Tue Nov 29, 2011 9:09 am

Paizo
 
Posts: 1
Joined: Tue Nov 29, 2011 8:54 am

Re: SQL Error [911] [22019]: ORA-00911: invalid character

Postby Serge » Tue Nov 29, 2011 11:53 am

Hi,

How do you execute your script?
There are two actions on SQL editor toolbar - execute statement (Ctrl+Enter) and execute script (Alt+X). As you script is multiline an contains many statements it should be executed as script.
It seems that you just selected your delete statements and execute them all as a single statement. In case of Oracle it leads to "invalid character" error. But execute script action should work.

Ctrl+C doesn't work in error log view (clipboard copy avaiable only thru context menu) but it should work in execution log. At least it works in my environment. Anyway I'll test this issue.

Thanks!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 4 guests