在Oracle中使用脚本的一个错误

Posted by 猪头小队长 | 程序设计 | Wednesday 28 July 2004 14:46

Q:在Oracle中,使用脚本创建数据库(或其他)时出现错误(错误如下),而在终端直接输入sql没有问题。

错误1:
MGR-00072: Warning: PROCEDURE NAD_SP_CREATEAGENT created with compilation errors.
Errors for PROCEDURE NAD_SP_CREATEAGENT:
LINE/COL ERROR
——————————————————————————–
1/30 PLS-00103: Encountered the symbol "" when expecting one of the followin
2/58 PLS-00103: Encountered the symbol "" when expecting one of the followin
3/58 PLS-00103: Encountered the symbol "" when expecting one of the followin
4/56 PLS-00103: Encountered the symbol "" when expecting one of the followin
5/53 PLS-00103: Encountered the symbol "" when expecting one of the followin
6/53 PLS-00103: Encountered the symbol "" when expecting one of the followin
7/57 PLS-00103: Encountered the symbol "" when expecting one of the followin
8/55 PLS-00103: Encountered the symbol "" when expecting one of the followin

错误2:
MGR-00072: Warning: TYPE NAD_AD_OBJ created with compilation errors.

A:由于Dos/Windows下的编码与Unix/Linux下的编码不同所致,使用dos2unix命令将脚本转化之后即可

[@more@]

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.