Skip to primary content
Skip to secondary content

dotJava

dotJava

Main menu

  • Home
  • Nop
  • IceCo
  • About

Monthly Archives: March 2016

SP2-0027: Input is too long (> 2499 characters) add newline after comma fix

Posted on March 14, 2016 by kuperusm
Reply

Having a big file exported using SQL Developer I got the “SP2-0027: Input is too long (> 2499 characters)” error recently.
Since the file was too big to edit by hand, I used the following to add newlines after every comma in the file:

user@server:~/work$ cat file.sql | perl -pe 's/,/,\n/g' > new_file.sql
Posted in Linux, Oracle | Leave a reply

Search

Archive

  • May 2025 (2)
  • April 2025 (1)
  • February 2025 (1)
  • October 2024 (1)
  • May 2024 (1)
  • August 2023 (1)
  • March 2023 (1)
  • May 2022 (1)
  • April 2022 (1)
  • December 2019 (1)
  • November 2019 (1)
  • October 2019 (1)
  • August 2019 (1)
  • July 2019 (1)
  • May 2019 (1)
  • March 2018 (1)
  • April 2016 (1)
  • March 2016 (1)
  • October 2015 (2)
  • September 2015 (2)
  • June 2015 (1)
  • December 2014 (1)
  • November 2014 (1)
  • December 2013 (3)
  • November 2013 (2)
  • August 2013 (1)
  • May 2013 (1)
  • January 2013 (1)
  • May 2012 (1)
  • December 2011 (1)
  • September 2011 (1)
  • October 2010 (1)
  • April 2010 (1)
  • March 2010 (2)
  • January 2010 (1)
  • December 2009 (1)
  • November 2009 (1)
  • September 2009 (1)
  • August 2009 (1)
  • July 2009 (2)
  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • February 2009 (1)
  • January 2009 (2)
  • December 2008 (1)

Categories

  • Apex
  • General
  • Java
  • JavaFX
  • JDeveloper
  • Linux
  • MySQL
  • News
  • Oracle
  • Php
  • Pl/SQL

Mastodon

Mastodon

Proudly powered by WordPress