Re: Strange error

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

You didn't give any details about your environment so this is just a shot in the dark. What typically causes your symptoms is problems in dealing with end of line terminators. It is possible that your editor corrects the data format so that sqlplus can deal with it as a script. If this is the case, a simple correction in your script generator (e.g. usage of new lines and carriage returns) should make things run properly.

Hope this helps,
Shmuel Received on Sun Feb 22 1998 - 00:00:00 CST