Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!e39g2000hsf.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.server Subject: Re: SQL Plus error - String beginning '...' too long. Maximum size is 79 characters Date: Thu, 22 May 2008 06:14:03 -0700 (PDT) Organization: http://groups.google.com Lines: 64 Message-ID: References: <7802ca95-3314-490a-91d6-935dcec16d51@j22g2000hsf.googlegroups.com> <678cdc4a-0600-4d14-8a5d-747930a00588@k13g2000hse.googlegroups.com> NNTP-Posting-Host: 192.85.50.2 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1211462043 17639 127.0.0.1 (22 May 2008 13:14:03 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 22 May 2008 13:14:03 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: e39g2000hsf.googlegroups.com; posting-host=192.85.50.2; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:444832 X-Received-Date: Thu, 22 May 2008 09:14:03 EDT (text.usenetserver.com) On May 22, 6:07=A0am, gazzag wrote: > On 22 May, 10:33, Morris wrote: > > > > > > > Hi guys, > > > I had trouble finding a correct oracle group so please let me know if > > this is not where I should post my problem? But hopefully you might be > > able to help me anyway... > > > We're using SQLPLUS at work, mine is: (sqlplusw.exe) > > version: SQL*Plus: Release 9.2.0.1.0 - Production on Thu May 22 > > 10:21:41 2008 > > > my friend's is: > > version: SQL*Plus: Release 8.1.6.0.0 - Production on Thu May 22 > > 10:25:01 2008 > > > Now, if we paste the same path trying to run the same script, for > > example: > > @\\SomeServer\DataServices\Data\Data\Data\Data\Datadata\Data\Database > > \SomeFolder\file.sql > > > He gets the error as per title - saying his maximum size is 79 chars, > > and I have no problems when running the script? > > > Is there any settings we could change (I went through Options --> > > Environment but nothing helpful there) or would upgrading his client > > be enough? Would it be enough if he just replaces his binary > > (sqlplusw.exe) with mine? Or does he need to download a completely new > > package? > > > Thanks in advance, > > Morris > > Well, for one thing, your friend is on a desupported version of Oracle > that's not even patched to the required level (8.1.7.4). > > I don't run scripts via SQL*Plus for Windows (sqlplusw.exe), I use the > DOS based version (sqlplus.exe) from a command prompt. =A0If I were you, > I'd open a command prompt and CD to the relevant directory (\ > \SomeServer\DataServices\Data\Data\Data\Data\Datadata\Data\Database > \SomeFolder) and start SQL*Plus from there. =A0Next simply run your > script as follows: > > SQL> @file.sql > > HTH > > -g- Hide quoted text - > > - Show quoted text - Since the client is a free download you might just consider upgrading the client. Another option to try is to set the SQLPATH variable in the OS. This variable is used to tell SQLPlus where to look for scripts. The SQLPATH environment variable works on both UNIX and Windows. HTH -- Mark D Powell --