Click here to Skip to main content
15,881,089 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have exported insert query (export.sql). when I run this .sql file via cmd(sqlplus) its show me error like
SP2-0027: Input is too long (> 2499 characters)
.

What I have tried:

all the insert query in single line. I have seen somewhere they ask me for wrap text even though its not possible.

what the super secret behind this.
Posted
Updated 5-Jan-21 19:48pm

If you get an error message and you don't understand it, then google it: SP2-0027: Input is too long (> 2499 characters) - Google Search[^]
It explains that the error is simple: one or more lines of text in the query you are passing exceeds the maximum limit for a single line in sqlplus, and that to fix it you need to break the query up into multiple lines, all of which are shorter than 2500 characters.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900