Re: Strange error

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/02/18
Message-ID: <34EB2DC0.D47DB4DF@ubs.com>#1/1

Chris Remshaw wrote:
>
> I get a somewhat strange occurance when using PLSQL and SQLPLUS. I'm
> running an automated script which generates a .sql file so that it can
> be run through sqlplus. the file is generated just fine, but when run,
> SQLPLUS says the Input is too long and it truncates the line. HOWEVER,
> if I simply go into the file, hit space once (i.e. modify in any way)
> and delete that space (i.e. return it to what it was) it works
> ABSOLUTELY fine. This doesn't help me, though, seeing as I need it to
> be automated. Anyone have any clue what is going on?
>
> Thanks,
> Chris

Hi Chris

Is it the following message ?
>> last line truncated <<

If so, then SQLPLUS can't find a CR/LF on the last line (the processing is done
anyway, but you get this message). If you add an additional CR/LF on the last line in your script, the problem should be solved. If not, no idee sorry :-(

rgds
eugen Received on Wed Feb 18 1998 - 00:00:00 CST