Created On:  18 October 2010

Problem:

How do you execute an SQL Script in Oracle to avoid the error ORA-00911: invalid character?

Resolution:

Once in sqlplus, you type @TT_ora to execute the script. The script must be in the same directory you start sqlplus from.

If the script is on your desktop, then:

1. start->accessories->MSDOS prompt
Cd desktop
Sqlplus
(enter your database login and password)
At the sql> prompt, type @TT_ora