Saturday, February 11, 2012

Input is too long error creating Oracle tables with IBM Datacap Taskmaster Capture

Input is too long error creating Oracle tables


with IBM Datacap Taskmaster Capture


(Abstract)


When attempting to create a table in Oracle programmatically using Taskmaster,


an error is received stating input is too long.


Symptom


The exact error message is:


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


Cause


Oracle cannot accept commands with 2500 or more characters in them.


Resolving the problem


To resolve the problem, break-up any statements that exceed 2499 characters


into separate lines and try again.

No comments:

Post a Comment