ORA-00911 invalid character
Explanation: This generally occurs when parsing a SQL statement and an invalid character is found in the statement. Diagnosis: 1) Check the statement that the error is raised against IN FULL. Where is the statement being submitted ? 2) If running catalog scripts check these are being run in SQLDBA or Server Manager connected internal. Eg: The following is invalid in SQLPLUS but runs fine in SQLDBA: SQL> create table xxxx ( 2 commit_comment VARCHAR2(50)); -- commit comment 3 / commit_comment VARCHAR2(50)); -- commit comment * ERROR at line 2: ORA-00911: invalid character 3) If using 'dbms_sql.parse' do not pass in the trailing semi-colon. (If you do, you get an error when you *execute* the procedure - you do not get a compilation error.)
|