CODEWITHSUNDEEP
oracle-databaseoracle11g
mkbsc
mkbsc

Reputation: 107

Unknown Character

Facing a typical issue of some unknown character. Actually trying to compile some packages in database through script and got an error as below: SP2-0734: unknown command beginning "?SET DEF..." - rest of line ignored.

When i open the log file in notepad++ it shows the line as shown above. Now, if I open the same log file in scite editor it shows the same file as:

SP2-0734: unknown command beginning "SET DEF..." - rest of line ignored.

Not getting what could be the issue. Any help would be welcomed.

Upvotes: 1

Views: 2276

Answers (1)

Alex Poole
Alex Poole

Reputation: 191235

Your script has an unprintable character at the start (as you discovered from comments), which some editors don't display at all, and others display as an unknown character. "" is the byte order mark:

The UTF-8 representation of the BOM is the byte sequence 0xEF,0xBB,0xBF. A text editor or web browser interpreting the text as ISO-8859-1 or CP1252 will display the characters  for this.

From that article some editors (notable Notepad) add that automatically. It should be safe to open the file with a hex editor and remove the extra character, and you'll then be able to run the script normally.

Upvotes: 1

Related Questions