Re: SQLPLUS Error: Input too long

From: Svend Jensen <Master_at_OracleCare.Com>
Date: Mon, 11 Mar 2002 21:35:34 +0100
Message-ID: <3C8D1516.7090702@OracleCare.Com>

R Chin wrote:

> <SP2-0027: Input is too long (> 2499 characters) - line ignored>
>
> On 8.1.7.2/Unix...SQL+ gave me this error message when I tried to either
> paste the SQL or using @mysql.sql
> ....is there anyway around this rather disappointing limitation ? I can run
> this query in other tools though.
> My query is about 3400 bytes.
> Thanks
>
> Robert Chin
>
>
> SP2-0027 Input is too long (> max_characters characters) - line ignored
> Cause: The input value specified was too long.
> Action: Re-enter with fewer characters.
>

Edit the query and put some newlines into it. Or replace FROM, WHERE, AND with

<nl>FROM, ....

/Svend Jensen Received on Mon Mar 11 2002 - 14:35:34 CST