Re: Problem with SqlPlus

jdasssin_at_hotmail.com (dassin) wrote in message news:<4d004ac8.0108140453.42bb2e6f_at_posting.google.com>...
> Hello!
>
> I have a nasty problem with SqlPLus.
>
> I'd like to run an sql script using the START command,
> but I get an error saying that the command is "too long",
> and that the "maximum allowed is 79 characters".
>
> It's true that the full path to the script is over 80 characters long,
> but I'm a bit surprised that SqlPLus has such a limit. (And so small
> by default!)
>
> I've looked for that limit in my Oracle documentation, but I didn't
> found anything about it.
>
> I've tried using a local variable for the script path, but it simply
> replace my variable first, then stop with the same error.
>
> How is it possible to change that limit, or to circumvent it?
>
> Thanks for any help

In my opinion the best way to resolve this is to set an environment variable
SQLPATH to the directory where your sql scripts are held. Then you could call these scripts without its path. Received on Mon Aug 20 2001 - 12:10:49 CEST