OraFAQ Forum: SQL & PL/SQL » Need to pass 4000 characters but getting Error SP2-0027: Input is too long (>

Home » SQL & PL/SQL » SQL & PL/SQL » Need to pass 4000 characters but getting Error SP2-0027: Input is too long (>

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to pass 4000 characters but getting Error SP2-0027: Input is too long (> [message #16729]

Thu, 09 December 2004 08:37

Lisa
Messages: 31
Registered: September 2000

Member

How can you get around this error (SP2-0027: Input is too long (> 2499 characters) - line ignored) in SQL Plus, if you need to pass a 4000 character string into a stored procedure?

Report message to a moderator

Re: Need to pass 4000 characters but getting Error SP2-0027: Input is too long ( [message #16734 is a reply to message #16729]

Thu, 09 December 2004 12:24

sverch
Messages: 582
Registered: December 2000

Senior Member

http://oracle.ittoolbox.com/groups/groups.asp?v=oracle-db-l&i=397423

http://www.fmpromigrator.com/support/fmpro_migrator/fmpro_migrator_troubleshooting_sp2_0027_error.html

Report message to a moderator

Re: Need to pass 4000 characters but getting Error SP2-0027: Input is too long ( [message #16818 is a reply to message #16734]

Mon, 13 December 2004 18:49

geetha
Messages: 20
Registered: August 2000

Junior Member

what is the datatype of the specified column. if it is varchar2 or some thing char datatype then change it to long datatype.

Report message to a moderator

Re: Need to pass 4000 characters but getting Error SP2-0027: Input is too long ( [message #109397 is a reply to message #16729]

Thu, 24 February 2005 02:17

ANKUR SETHI
Messages: 1
Registered: February 2005

Junior Member

What about facing this problem in a dynamic query when we are not sure whether the length of the sql query would exceed 2499 characters or not?

Best regards,
Ankur

Report message to a moderator

Previous Topic:	Background process
Next Topic:	Urgent - Query in chunks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 25 20:40:51 CST 2025