ORA-06550 和 PLS-00103
你好，
我正在使用 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 中吗？
HI,
I am using UNIX OS and working on oracle. I am getting the error message below
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>
On googling, I found
"The problem appears to be with Windows CRLF characters on line breaks. Oracle does not treat this as white space, instead it sees it as an empty string. In order to get round this problem, convert the CRLF characters to LF characters and Oracle should be happy."
Anyone have any idea about why it is happening in UNIX/ksh shell?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
正如@JOTN 所说，dos2unix 命令是你的朋友。应该调用诸如
共享和享受之类的东西。
As @JOTN said, the dos2unix command is your friend here. Should be invoked something like
Share and enjoy.