惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

aimingoo的专栏
aimingoo的专栏
月光博客
月光博客
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
阮一峰的网络日志
阮一峰的网络日志
博客园_首页
Last Week in AI
Last Week in AI
The Cloudflare Blog
IT之家
IT之家
Hugging Face - Blog
Hugging Face - Blog
美团技术团队
S
SegmentFault 最新的问题
量子位
大猫的无限游戏
大猫的无限游戏
Recent Announcements
Recent Announcements
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Microsoft Security Blog
Microsoft Security Blog
云风的 BLOG
云风的 BLOG
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
I
InfoQ
人人都是产品经理
人人都是产品经理
G
Google Developers Blog
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Engineering at Meta
Engineering at Meta

博客园 - 胖在一方

ora-12557(win7 64bit oracle database + 32 bit oracle client) 设置双网卡同时访问2个网络(转) oracle pl/sql developer 测试存储过程 日期为 yyyy-mm-dd hh24:mi:ss ASP.NET2.0学习笔记二 - 胖在一方 - 博客园 asp.net2.0学习记录笔记一 ora01991 oracle 更新多字段 Oracle 函数 oracle 9.2.01 wrap 问题 - 胖在一方 安装IE8 asp.net 不能调试 - 胖在一方 combo box 绑定Oracle 数据源显示为 datarowview BT用户,密码中含有@符号 - 胖在一方 - 博客园 .net 访问Oracle的连接字符串 (果然BT) 系统提示"System.Data.OracleClient 需要 Oracle 客户端软件 8.1.7 或更高版本"解决办法 Javascript(二十三) MouseEvent Javascript(二十二)IE与DOM事件的区别 Javascript(二十一)IE与DOM事件的相似性 - 胖在一方 - 博客园 Javascript(二十) 事件对象 JavaScript(十九) Dom Event 二
sp2-00027 错误解决
胖在一方 · 2012-02-21 · via 博客园 - 胖在一方

       在网上找了一下,根据metalink的资料解决。

 原因:

      sqlplus最多接受2499个字符,太长了,会报此错误,

解决方法:

      比如利用word,另存为txt文件,选择 windows(默认),选项中,选中“插入换行符”复选框,保存。

再执行,问题解决。

参考Metalink: Doc ID: Note:115005.1

SP2-00027: Input is too long (> 2499 characters) - line ignored

Problem Description
-------------------

You are trying to run a SQL query or script from an output file from a vendor
package called SQLBacktrack. The file has a SQL statement that is extremely
long (in this case thousands of lines long and each row has thousands of
characters) and you get the following error:

SP2-0027: input is too long (> 2499 characters) - line ignored

This fails with the same error from either SQL*Plus or Server Manager.

Solution Description
--------------------

Open the file in a text editor and then resave the file as a different file
type. In Microsoft Word, you click on File, Save As, then select file type
'text only with line breaks' and save the file. Once this is done, you can
successfully run the script from SQL*Plus or Server Manager.

Explanation
-----------

The output file that comes directly from SQLBacktrack doesnot have the proper
type of carriage returns that SQL*Plus or Server Manager recognizes. As a
result, the SQL statement is read by SQL*Plus or Server Manager as being all on
one line and you get the above error message. Once you save the file as 'text
only with line breaks' it reformats the carriage returns in the file so that
SQL*Plus or Server Manager can recognize it and run the statement successfully.