开发者

ORA-06550 and PLS-00103

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 t开发者_如何学JAVAhis 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?


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

Share and enjoy.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜