Did you edit & save the sql file in wordpad ?
You see the extra characters & formatting stuffs because the editor you used added that to the sql file & oracle cannot understand it. So open a simple text editor & create the sql like
1. Open the sql in wordpad
2. Create a new document in notepad.
3. copy the contents of the sql opened in
word pad & paste it in notepad
4. Save & Execute the new sql created in notepad.
[ September 14, 2006: Message edited by: Srinivasa Raghavan ]
Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified