ORA-06550和PLS-00103 [英] ORA-06550 and PLS-00103

问题描述

HI

我正在使用UNIX OS并在oracle上工作.我收到以下错误消息

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> 

在谷歌搜索中，我发现 问题似乎出在换行符上是Windows CRLF字符.Oracle并未将其视为空格，而是将其视为空字符串.为了解决此问题，请将CRLF字符转换为LF字符，Oracle应该将其转换为LF字符.要开心."

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."

任何人都知道为什么它在UNIX/ksh shell中发生吗?

Anyone have any idea about why it is happening in UNIX/ksh shell?

推荐答案

正如@JOTN所说，dos2unix命令是您的朋友.应该被调用类似

As @JOTN said, the dos2unix command is your friend here. Should be invoked something like

dos2unix the_file_you_want_converted > another_file_to_hold_the_unix_version

分享并享受.

这篇关于ORA-06550和PLS-00103的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！