ORA-06550和PLS-00103

Question

嗨,

我使用的是UNIX操作系统，在oracle上工作。我收到以下错误消息

E ORA-06550: line 1, column 8:
PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin function package pragma procedure subtype type use
   <an identifier> <a double-quoted delimited-identifier> form
   current cursor
The symbol "" was ignored.
ORA-06550: line 2, column 27:
PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin function package pragma procedure subtype type use
   <an identifier> <a double-quoted delimited-identifier> 

在谷歌搜索中，我发现“问题似乎出在Windows CRLF字符的换行符上。Oracle不会将其视为空格，而是将其视为空字符串。为了解决此问题，请将CRLF字符转换为LF字符，Oracle应该会很高兴。”

有人知道为什么在UNIX/ksh shell中会发生这种情况吗？

Answer 1

正如@JOTN所说，dos2unix命令是您的朋友。应该像这样调用

dos2unix the_file_you_want_converted > another_file_to_hold_the_unix_version

分享和享受。